{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Explicacao","Uniforme","Discreta","Uniforme Discreta","Normal","Triangular","Binomial","Poisson","Cumul","General"],"not_rendered":{"charts":9,"images":0,"macros":1,"external_links":0,"defined_names":52,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Explicacao","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Uniforme","index":1,"n_rows":520,"n_cols":6,"rows_kept":520,"cut":false,"hidden":false,"merged":[]}
["Distribuição Uniforme"]
[]
["Características"]
["Contínuo"]
["Simétrico"]
["Limitado em ambas direções"]
["Não necessariamente positivo (depende dos limites)"]
[]
["Parâmetros"]
["MinVal",50]
["MaxVal",100]
[]
["Excel",null,"Exemplo"]
["=MinVal + (MaxVal-MinVal)*RAND()",null,{"$f":"B10+(B11-B10)*RAND()","v":79.900801226880816}]
["Função UDF chamada Suniforme",null,{"$f":"Suniforme(B10,B11)","v":97.501534223556519}]
["@RISK"]
["=RISKUNIFORM(MinVal,MaxVal)",null,{"$f":"_xll.RiskUniform(B10,B11)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,55.052900416191939,null,{"$f":"55","v":55},"<=55",{"$f":"FREQUENCY(B21:B520,D21:D29)","v":43}]
[2,84.859429620447102,null,{"$f":"60","v":60}," 55- 60",50]
[3,65.024652410990086,null,{"$f":"65","v":65}," 60- 65",44]
[4,67.677678333687751,null,{"$f":"70","v":70}," 65- 70",60]
[5,73.045265147411186,null,{"$f":"75","v":75}," 70- 75",43]
[6,88.115362725266763,null,{"$f":"80","v":80}," 75- 80",52]
[7,91.54367484490831,null,{"$f":"85","v":85}," 80- 85",46]
[8,60.99700184448389,null,{"$f":"90","v":90}," 85- 90",59]
[9,62.12146467627452,null,{"$f":"95","v":95}," 90- 95",55]
[10,55.470935692043042,null,null,">95",48]
[11,90.625781554735966]
[12,96.366999061886901]
[13,80.864136791287535]
[14,77.253777234971295]
[15,69.912574653020656]
[16,71.962017315840683]
[17,99.538408871280737]
[18,77.279874848116975]
[19,76.217233356866473]
[20,90.015147785662322]
[21,99.332752989748315]
[22,57.533462318127661]
[23,96.699776331743266]
[24,99.069704050547003]
[25,74.129830422114424]
[26,89.630925585805784]
[27,75.886528198637961]
[28,92.159788823506091]
[29,61.852385653246913]
[30,62.84585053791033]
[31,69.664482817355747]
[32,85.452099250870788]
[33,85.633092802071701]
[34,63.170759146141052]
[35,60.591924251285093]
[36,83.854421870866361]
[37,94.843543778502038]
[38,69.009798668509646]
[39,55.799073433249205]
[40,63.266537940414949]
[41,51.235462815188434]
[42,94.046657965642311]
[43,92.79423057313366]
[44,92.704808745590569]
[45,64.49304044501028]
[46,96.716560445906396]
[47,63.906489246611557]
[48,86.197240972062573]
[49,53.669936626520311]
[50,53.013959055957393]
[51,60.658238557535896]
[52,85.127223560058553]
[53,95.028933335142312]
[54,89.72063443259816]
[55,56.917112546603079]
[56,93.528670188818722]
[57,55.636274388746898]
[58,64.417121883285375]
[59,51.120365745693228]
[60,63.678338453215076]
[61,95.528299025249609]
[62,93.991076976398304]
[63,96.933335207726671]
[64,92.851425083601001]
[65,54.412096045444969]
[66,91.761612315037553]
[67,51.360895983828712]
[68,75.925807181798191]
[69,77.918682440007544]
[70,99.946593314121884]
[71,86.059287990971171]
[72,98.833709327942245]
[73,56.42565972076801]
[74,66.970467662593038]
[75,77.529264326208363]
[76,75.471297692393534]
[77,64.180986996909681]
[78,82.039646650002254]
[79,71.936099672220308]
[80,95.001230875560779]
[81,67.654778882445981]
[82,98.149754501931795]
[83,89.305313472062323]
[84,78.049959124043198]
[85,89.214907228267393]
[86,90.170238814063936]
[87,72.481742921964894]
[88,53.763586617262014]
[89,72.750518130257376]
[90,93.404907257701836]
[91,90.160527889674611]
[92,77.11075449437601]
[93,65.286239266797836]
[94,86.722189221594903]
[95,59.186695283542967]
[96,83.100729675480494]
[97,92.83249289388408]
[98,68.479060835635693]
[99,93.422816778068068]
[100,66.049927406446187]
[101,86.903408708091774]
[102,88.943272169354785]
[103,72.442325233306136]
[104,66.642466299575176]
[105,56.227878127803308]
[106,74.557443156309304]
[107,89.215588113633913]
[108,96.85721399856638]
[109,95.265029920335422]
[110,58.425197614269386]
[111,54.432119739642779]
[112,88.414313031755995]
[113,77.534634875654021]
[114,78.215463798113106]
[115,64.636311268805372]
[116,53.779320937635056]
[117,77.277278513881157]
[118,50.718634826808938]
[119,68.278984090592957]
[120,78.469103713368895]
[121,55.633918995897112]
[122,91.284808705553132]
[123,68.672647237212118]
[124,94.634866660175433]
[125,69.591819582915761]
[126,71.826473815672216]
[127,68.36569371676795]
[128,80.044342378038422]
[129,76.052844715366462]
[130,75.554299614035969]
[131,79.342859447252096]
[132,86.788981462883271]
[133,65.153296976639169]
[134,81.095957573223927]
[135,53.965676632229091]
[136,57.476555121864031]
[137,87.81420182667938]
[138,83.8424898181148]
[139,77.658853705411033]
[140,98.168590841775227]
[141,74.297007074507491]
[142,81.472828737978361]
[143,55.217385685517193]
[144,50.511167464373777]
[145,80.742017614834722]
[146,77.921345291852248]
[147,76.098461280846962]
[148,73.55458919802291]
[149,90.186863783025942]
[150,85.755563097746702]
[151,65.951532970349916]
[152,70.5716518066059]
[153,94.758742676604783]
[154,86.178176935535731]
[155,66.442033896433728]
[156,87.781246875638672]
[157,60.1919156474207]
[158,55.369923318712125]
[159,98.583263071750451]
[160,96.792977661157437]
[161,64.399960227239546]
[162,82.575741719619941]
[163,86.92577838736014]
[164,58.635892263845065]
[165,73.664273222418558]
[166,67.393667372713878]
[167,83.773617423050084]
[168,51.263061774875673]
[169,65.096041053988387]
[170,68.785541220010046]
[171,53.366671718692338]
[172,74.64929927744987]
[173,91.334553835100593]
[174,57.219564522843157]
[175,63.909528842656627]
[176,66.049113730729744]
[177,78.912299496846458]
[178,58.259708528982792]
[179,79.163813139979055]
[180,78.375197734305686]
[181,83.383298616077141]
[182,67.942058493586458]
[183,69.522815512571214]
[184,94.137498961874741]
[185,84.943654571749363]
[186,92.197899150580838]
[187,86.133907854340876]
[188,81.675387481726162]
[189,94.546808032600225]
[190,54.768038166828603]
[191,87.469186423711562]
[192,95.446217271275955]
[193,87.866171201174836]
[194,94.233716738067983]
[195,79.89843456557368]
[196,93.092218499148998]
[197,69.244230142261813]
[198,58.150577153334702]
[199,57.38457290012586]
[200,84.45680213610143]
[201,60.820128652229634]
[202,75.049843547220718]
[203,75.079827254672978]
[204,69.549818143244082]
[205,59.330334800108197]
[206,93.784421862608639]
[207,67.373462679519889]
[208,85.343325564849351]
[209,67.366722385449492]
[210,69.14689749949676]
[211,52.246692557592823]
[212,75.333958119105333]
[213,65.369037733520273]
[214,99.885930902614476]
[215,90.293744576735421]
[216,85.431838118599984]
[217,86.648512770390511]
[218,85.610268005275316]
[219,89.00842980885875]
[220,62.355502801751015]
[221,53.959365996739109]
[222,95.499803974759459]
[223,64.141186112619891]
[224,91.155162040006232]
[225,95.412744901207873]
[226,59.134024762588268]
[227,65.82354337936485]
[228,63.585878742262757]
[229,87.481477762546774]
[230,66.159455971794316]
[231,62.583448991938496]
[232,92.618899827960263]
[233,70.78156039766327]
[234,56.271015451063107]
[235,98.209094890814015]
[236,72.087272684483807]
[237,79.671384315450936]
[238,63.231712043609932]
[239,59.210330293155536]
[240,65.220159080490461]
[241,87.748679496793073]
[242,90.347688004735005]
[243,65.210244502484599]
[244,90.377608901300476]
[245,59.063369671983246]
[246,71.919898547456256]
[247,85.889984567844238]
[248,86.104790798343885]
[249,95.716780535222014]
[250,95.067986415384368]
[251,73.260935489844357]
[252,56.213795761447471]
[253,86.254523175617379]
[254,66.238457738302301]
[255,88.459797866919857]
[256,74.241201019883093]
[257,83.401566271888555]
[258,97.348706217447216]
[259,72.21011154917565]
[260,86.07187445404341]
[261,72.445363160296637]
[262,96.477947273287512]
[263,70.486520956656079]
[264,58.688665319407207]
[265,91.948451898182014]
[266,86.312442045572851]
[267,85.05967957091886]
[268,81.679415994191686]
[269,84.11082895653044]
[270,63.017532085419646]
[271,55.748960906357695]
[272,71.111411338891742]
[273,95.737109255769127]
[274,94.716350908587586]
[275,69.848623238698337]
[276,93.895177256372051]
[277,55.102184829934984]
[278,69.123564791496506]
[279,73.096167287264038]
[280,88.025278220093242]
[281,56.823749535812418]
[282,76.610541213755539]
[283,52.691610293100986]
[284,94.871038544800797]
[285,89.03589848866558]
[286,82.125407184630504]
[287,64.19031025619546]
[288,73.60337609560986]
[289,69.322984984460632]
[290,81.601882387884942]
[291,72.65328141798237]
[292,88.443156004893325]
[293,60.801474057292104]
[294,91.843066665755259]
[295,51.324074382492533]
[296,64.300860459185756]
[297,59.316919663323766]
[298,62.03436350268494]
[299,50.050309868811397]
[300,54.659571596694896]
[301,72.219001140588446]
[302,73.376551719180469]
[303,91.68078407141256]
[304,57.546715342729172]
[305,76.857730943189424]
[306,80.341943063376718]
[307,98.789175422762554]
[308,69.05817695104318]
[309,80.922186194981293]
[310,97.356970911285686]
[311,53.377669736648372]
[312,82.660833623640713]
[313,72.613367775373305]
[314,96.451271941231681]
[315,58.508084836393778]
[316,68.467528223324223]
[317,80.161031267109607]
[318,72.054424283439658]
[319,57.067237660964018]
[320,67.907418327648671]
[321,79.321745837608006]
[322,79.432221148209607]
[323,64.410246566511063]
[324,83.597879705165582]
[325,75.342934431147853]
[326,53.525398303099657]
[327,83.50308474174409]
[328,94.3615986687429]
[329,85.826875723986305]
[330,66.312835269518189]
[331,68.921531938132716]
[332,88.931514401428359]
[333,56.969286428009205]
[334,55.928359478378894]
[335,82.984787159150557]
[336,54.161040017686048]
[337,76.140363694660266]
[338,85.07819525854643]
[339,63.521984184485227]
[340,59.973025829395709]
[341,55.653020495264926]
[342,78.880633996843741]
[343,97.27283300237923]
[344,77.059266366448611]
[345,59.62133489189636]
[346,51.696323314155244]
[347,70.157618318669421]
[348,78.535857652381452]
[349,61.224354038187734]
[350,94.947359041733705]
[351,88.579498866808365]
[352,99.824720924897463]
[353,89.150553418051317]
[354,58.151468681962996]
[355,66.140275558546747]
[356,74.212610487593594]
[357,52.613948656744668]
[358,82.156107889394548]
[359,65.701931743849414]
[360,69.238006345131225]
[361,97.026665533820534]
[362,59.44855765145509]
[363,54.851044940456021]
[364,52.67871021854706]
[365,68.179406350694094]
[366,50.516120166751122]
[367,79.382507662766329]
[368,76.174106028154966]
[369,66.461652510012755]
[370,80.455650835193609]
[371,65.513202436384304]
[372,65.72747773020123]
[373,70.125138306315478]
[374,59.549656324349328]
[375,97.74111143478504]
[376,76.021751023808505]
[377,70.183154823314723]
[378,79.329869773860707]
[379,59.217399085995083]
[380,84.642773557696586]
[381,87.245460138243658]
[382,98.230367690963902]
[383,81.007442956397298]
[384,84.663624777902641]
[385,92.025293781780164]
[386,90.976580863057734]
[387,91.567006089987672]
[388,90.133159768888447]
[389,58.328440253457003]
[390,54.178079201230886]
[391,93.4821852885581]
[392,99.108068929051598]
[393,50.911302215723623]
[394,60.465410621666805]
[395,91.364065389656162]
[396,97.052541813228913]
[397,63.579497721122323]
[398,74.813469142348424]
[399,53.646797003843091]
[400,75.759724743027476]
[401,96.82305127276166]
[402,59.752899792174659]
[403,93.795208947364955]
[404,73.313422071280371]
[405,71.684512044576195]
[406,74.159139782845642]
[407,77.47815732713957]
[408,73.549459837647603]
[409,89.811415537095755]
[410,98.478339817372571]
[411,66.341696416041884]
[412,52.366851947345481]
[413,55.419324879988416]
[414,83.755996366231898]
[415,78.206662763485824]
[416,78.201350194273317]
[417,76.026607958299849]
[418,67.883108462848298]
[419,90.574563633225409]
[420,93.355791906784717]
[421,57.798666532666985]
[422,51.270367322477753]
[423,86.843824053983568]
[424,53.762384172590473]
[425,60.941309011022]
[426,65.162147247079858]
[427,68.01446357130672]
[428,80.613083803256146]
[429,61.662381778619448]
[430,96.817797821580513]
[431,58.158755742288548]
[432,87.706495015831507]
[433,76.05390048125291]
[434,85.922976384846805]
[435,60.11742558047515]
[436,73.802975846426932]
[437,79.592137758904443]
[438,84.951280200460346]
[439,67.089198721038471]
[440,93.586989318791382]
[441,78.38844985014677]
[442,63.532328291414245]
[443,61.562499979268338]
[444,65.878646394337153]
[445,54.752588785240377]
[446,85.740809845720491]
[447,71.05984482103392]
[448,89.30233737405824]
[449,98.821700625957746]
[450,88.488197530988131]
[451,53.154301834454287]
[452,88.964666175555038]
[453,82.552860126053005]
[454,62.205647966582234]
[455,82.235029804117374]
[456,90.794056236755736]
[457,98.992651178102875]
[458,67.393570148336011]
[459,82.818776807872496]
[460,73.773380115784988]
[461,88.932467124299521]
[462,66.325977745576651]
[463,97.993789308255032]
[464,57.571146372653772]
[465,66.794875832672943]
[466,53.041902681049912]
[467,85.092580591193553]
[468,54.800336111806573]
[469,54.667304052314641]
[470,98.159447782120495]
[471,84.503018205389409]
[472,64.708145129425048]
[473,59.25966608334879]
[474,99.746954568508471]
[475,75.407167321598536]
[476,84.356615419201034]
[477,76.88638197332449]
[478,61.72371001982917]
[479,99.122454742277952]
[480,92.194373911791104]
[481,51.512537700446259]
[482,65.199106082711964]
[483,80.987188314192508]
[484,85.742783684583657]
[485,90.444916296091691]
[486,70.089293916408209]
[487,57.521903045059254]
[488,83.176155526921548]
[489,83.589779896512113]
[490,95.794713645396769]
[491,60.449061441761344]
[492,80.798769538145194]
[493,85.281984123887256]
[494,64.932430696737015]
[495,61.968222654275095]
[496,50.481037635715808]
[497,84.836970364956244]
[498,94.452304235266823]
[499,76.646244555500914]
[500,53.334129574423805]

{"sheet":"Discreta","index":2,"n_rows":523,"n_cols":6,"rows_kept":523,"cut":false,"hidden":false,"merged":[]}
["Distribuição Discreta Geral"]
[]
["Características"]
["Discreta"]
["Pode ser simétrica ou distorcida (ou enrolada, i.e., basicamente de qualquer forma)"]
["Limitado em ambas direções"]
["Não necessariamente positivo (depende dos valores possíveis)"]
[]
["Parâmetros",null,null,null,"Tabela Procura exigida para o método Excel"]
[null,"Valores","Probabilidades",null,"ProbAcum","Valor"]
[null,10,0.1,null,0,10]
[null,15,0.3,null,{"$f":"C11+E11","v":0.1},15]
[null,20,0.4,null,{"$f":"C12+E12","v":0.4},20]
[null,25,0.2,null,{"$f":"C13+E13","v":0.8},25]
[]
["Excel",null,"Exemplo"]
["=PROCV(ALEATÓRIO();$E$11:$F$14;2)",null,{"$f":"VLOOKUP(RAND(),$E$11:$F$14,2)","v":25}]
[]
["@RISK"]
["=RISKDISCRETE(Values,Probs)",null,{"$f":"_xll.RiskDiscrete(B11:B14,C11:C14)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,20,null,{"$f":"10","v":10},"10",{"$f":"FREQUENCY(B24:B523,D24:D26)","v":52}]
[2,20,null,{"$f":"15","v":15},"15",162]
[3,20,null,{"$f":"20","v":20},"20",179]
[4,15,null,null,"25",107]
[5,15]
[6,10]
[7,25]
[8,20]
[9,25]
[10,15]
[11,10]
[12,25]
[13,25]
[14,15]
[15,25]
[16,20]
[17,25]
[18,25]
[19,25]
[20,25]
[21,20]
[22,15]
[23,20]
[24,20]
[25,15]
[26,15]
[27,25]
[28,25]
[29,20]
[30,20]
[31,15]
[32,10]
[33,20]
[34,10]
[35,15]
[36,20]
[37,20]
[38,20]
[39,20]
[40,20]
[41,25]
[42,20]
[43,15]
[44,20]
[45,20]
[46,15]
[47,25]
[48,20]
[49,15]
[50,20]
[51,25]
[52,20]
[53,25]
[54,15]
[55,15]
[56,20]
[57,20]
[58,15]
[59,15]
[60,10]
[61,20]
[62,15]
[63,20]
[64,15]
[65,20]
[66,15]
[67,10]
[68,15]
[69,15]
[70,20]
[71,10]
[72,20]
[73,10]
[74,15]
[75,20]
[76,20]
[77,20]
[78,20]
[79,20]
[80,15]
[81,20]
[82,20]
[83,25]
[84,20]
[85,15]
[86,20]
[87,20]
[88,15]
[89,25]
[90,15]
[91,20]
[92,25]
[93,10]
[94,15]
[95,25]
[96,15]
[97,15]
[98,20]
[99,20]
[100,20]
[101,25]
[102,15]
[103,20]
[104,15]
[105,20]
[106,25]
[107,20]
[108,25]
[109,15]
[110,15]
[111,20]
[112,20]
[113,20]
[114,20]
[115,15]
[116,15]
[117,15]
[118,25]
[119,15]
[120,15]
[121,25]
[122,10]
[123,20]
[124,25]
[125,20]
[126,10]
[127,15]
[128,20]
[129,20]
[130,15]
[131,20]
[132,20]
[133,25]
[134,10]
[135,15]
[136,25]
[137,10]
[138,25]
[139,25]
[140,20]
[141,20]
[142,10]
[143,25]
[144,10]
[145,25]
[146,15]
[147,20]
[148,10]
[149,20]
[150,15]
[151,20]
[152,20]
[153,25]
[154,25]
[155,20]
[156,15]
[157,25]
[158,25]
[159,20]
[160,15]
[161,10]
[162,20]
[163,15]
[164,20]
[165,20]
[166,20]
[167,20]
[168,20]
[169,15]
[170,25]
[171,15]
[172,15]
[173,10]
[174,15]
[175,25]
[176,15]
[177,15]
[178,15]
[179,25]
[180,15]
[181,15]
[182,15]
[183,15]
[184,15]
[185,25]
[186,15]
[187,25]
[188,25]
[189,15]
[190,20]
[191,20]
[192,20]
[193,20]
[194,20]
[195,20]
[196,20]
[197,15]
[198,25]
[199,15]
[200,25]
[201,25]
[202,20]
[203,20]
[204,20]
[205,10]
[206,15]
[207,20]
[208,20]
[209,25]
[210,15]
[211,25]
[212,15]
[213,15]
[214,15]
[215,15]
[216,15]
[217,15]
[218,15]
[219,25]
[220,25]
[221,25]
[222,15]
[223,15]
[224,20]
[225,15]
[226,20]
[227,25]
[228,10]
[229,15]
[230,25]
[231,20]
[232,15]
[233,20]
[234,15]
[235,20]
[236,15]
[237,25]
[238,15]
[239,15]
[240,20]
[241,20]
[242,20]
[243,15]
[244,15]
[245,25]
[246,15]
[247,10]
[248,15]
[249,20]
[250,15]
[251,25]
[252,25]
[253,10]
[254,20]
[255,20]
[256,15]
[257,10]
[258,25]
[259,20]
[260,20]
[261,25]
[262,15]
[263,20]
[264,15]
[265,15]
[266,20]
[267,15]
[268,20]
[269,10]
[270,15]
[271,10]
[272,10]
[273,15]
[274,25]
[275,10]
[276,20]
[277,10]
[278,25]
[279,15]
[280,20]
[281,15]
[282,25]
[283,25]
[284,25]
[285,25]
[286,20]
[287,20]
[288,10]
[289,20]
[290,15]
[291,20]
[292,15]
[293,20]
[294,15]
[295,15]
[296,20]
[297,25]
[298,20]
[299,25]
[300,15]
[301,20]
[302,20]
[303,15]
[304,25]
[305,15]
[306,20]
[307,20]
[308,20]
[309,20]
[310,15]
[311,10]
[312,10]
[313,20]
[314,20]
[315,20]
[316,25]
[317,15]
[318,20]
[319,20]
[320,20]
[321,15]
[322,20]
[323,20]
[324,25]
[325,15]
[326,20]
[327,20]
[328,10]
[329,15]
[330,25]
[331,15]
[332,15]
[333,20]
[334,25]
[335,15]
[336,15]
[337,15]
[338,25]
[339,15]
[340,20]
[341,20]
[342,20]
[343,25]
[344,10]
[345,20]
[346,15]
[347,25]
[348,20]
[349,25]
[350,10]
[351,15]
[352,25]
[353,20]
[354,20]
[355,10]
[356,25]
[357,15]
[358,20]
[359,20]
[360,20]
[361,20]
[362,20]
[363,15]
[364,15]
[365,20]
[366,20]
[367,20]
[368,15]
[369,25]
[370,20]
[371,25]
[372,15]
[373,25]
[374,15]
[375,15]
[376,10]
[377,15]
[378,25]
[379,15]
[380,20]
[381,20]
[382,15]
[383,15]
[384,15]
[385,15]
[386,20]
[387,15]
[388,20]
[389,10]
[390,25]
[391,25]
[392,25]
[393,20]
[394,25]
[395,20]
[396,15]
[397,20]
[398,10]
[399,20]
[400,15]
[401,15]
[402,15]
[403,15]
[404,15]
[405,10]
[406,20]
[407,20]
[408,10]
[409,15]
[410,20]
[411,25]
[412,15]
[413,25]
[414,15]
[415,20]
[416,20]
[417,10]
[418,25]
[419,20]
[420,20]
[421,15]
[422,20]
[423,15]
[424,10]
[425,20]
[426,20]
[427,10]
[428,15]
[429,20]
[430,25]
[431,25]
[432,20]
[433,15]
[434,15]
[435,25]
[436,20]
[437,10]
[438,15]
[439,25]
[440,15]
[441,15]
[442,25]
[443,20]
[444,20]
[445,25]
[446,20]
[447,15]
[448,20]
[449,10]
[450,25]
[451,25]
[452,25]
[453,25]
[454,20]
[455,25]
[456,15]
[457,15]
[458,15]
[459,15]
[460,25]
[461,15]
[462,25]
[463,25]
[464,15]
[465,15]
[466,25]
[467,20]
[468,10]
[469,15]
[470,15]
[471,20]
[472,20]
[473,10]
[474,15]
[475,10]
[476,25]
[477,25]
[478,10]
[479,25]
[480,15]
[481,15]
[482,15]
[483,10]
[484,20]
[485,15]
[486,20]
[487,20]
[488,10]
[489,20]
[490,25]
[491,20]
[492,25]
[493,20]
[494,15]
[495,15]
[496,10]
[497,20]
[498,20]
[499,20]
[500,20]

{"sheet":"Uniforme Discreta","index":3,"n_rows":520,"n_cols":6,"rows_kept":520,"cut":false,"hidden":false,"merged":[]}
["Uniforme Discreta"]
[]
["Características"]
["Discreta"]
["Simétrico"]
["Limitado em ambas direções"]
["Não necessariamente positivo (depende dos limites)"]
[]
["Parâmetros"]
["MinVal",1]
["MaxVal",20]
[]
["Excel",null,"Exemplo"]
["=ALEATÓRIOENTRE(B10;B11)",null,{"$f":"RANDBETWEEN(B10,B11)","v":8}]
[]
["@RISK"]
["=RISKINTUNIFORM(MinVal,MaxVal)",null,{"$f":"_xll.RiskIntUniform(B10,B11)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,14,null,{"$f":"1","v":1},"1",{"$f":"FREQUENCY(B21:B520,D21:D39)","v":33}]
[2,5,null,{"$f":"2","v":2},"2",20]
[3,19,null,{"$f":"3","v":3},"3",23]
[4,18,null,{"$f":"4","v":4},"4",25]
[5,13,null,{"$f":"5","v":5},"5",17]
[6,1,null,{"$f":"6","v":6},"6",18]
[7,17,null,{"$f":"7","v":7},"7",27]
[8,14,null,{"$f":"8","v":8},"8",34]
[9,19,null,{"$f":"9","v":9},"9",22]
[10,3,null,{"$f":"10","v":10},"10",25]
[11,17,null,{"$f":"11","v":11},"11",29]
[12,16,null,{"$f":"12","v":12},"12",23]
[13,12,null,{"$f":"13","v":13},"13",29]
[14,6,null,{"$f":"14","v":14},"14",22]
[15,17,null,{"$f":"15","v":15},"15",19]
[16,5,null,{"$f":"16","v":16},"16",24]
[17,10,null,{"$f":"17","v":17},"17",31]
[18,16,null,{"$f":"18","v":18},"18",30]
[19,9,null,{"$f":"19","v":19},"19",21]
[20,15,null,null,"20",28]
[21,10]
[22,11]
[23,1]
[24,17]
[25,16]
[26,13]
[27,1]
[28,19]
[29,8]
[30,17]
[31,6]
[32,8]
[33,7]
[34,1]
[35,2]
[36,8]
[37,16]
[38,16]
[39,20]
[40,4]
[41,2]
[42,13]
[43,19]
[44,6]
[45,14]
[46,1]
[47,19]
[48,15]
[49,7]
[50,11]
[51,11]
[52,10]
[53,12]
[54,7]
[55,4]
[56,7]
[57,18]
[58,3]
[59,3]
[60,9]
[61,11]
[62,12]
[63,9]
[64,18]
[65,4]
[66,1]
[67,15]
[68,8]
[69,9]
[70,17]
[71,8]
[72,10]
[73,15]
[74,19]
[75,7]
[76,12]
[77,7]
[78,18]
[79,8]
[80,17]
[81,17]
[82,7]
[83,20]
[84,7]
[85,1]
[86,3]
[87,13]
[88,3]
[89,7]
[90,5]
[91,12]
[92,11]
[93,20]
[94,8]
[95,18]
[96,15]
[97,13]
[98,18]
[99,4]
[100,10]
[101,18]
[102,13]
[103,17]
[104,6]
[105,4]
[106,15]
[107,16]
[108,9]
[109,16]
[110,18]
[111,2]
[112,18]
[113,10]
[114,13]
[115,13]
[116,13]
[117,15]
[118,11]
[119,13]
[120,16]
[121,8]
[122,13]
[123,12]
[124,19]
[125,20]
[126,1]
[127,18]
[128,8]
[129,13]
[130,11]
[131,4]
[132,17]
[133,18]
[134,6]
[135,17]
[136,19]
[137,4]
[138,3]
[139,16]
[140,2]
[141,11]
[142,11]
[143,2]
[144,5]
[145,10]
[146,1]
[147,8]
[148,20]
[149,10]
[150,17]
[151,7]
[152,17]
[153,1]
[154,19]
[155,15]
[156,9]
[157,17]
[158,11]
[159,15]
[160,17]
[161,16]
[162,20]
[163,7]
[164,13]
[165,16]
[166,16]
[167,20]
[168,9]
[169,7]
[170,18]
[171,19]
[172,11]
[173,14]
[174,1]
[175,4]
[176,20]
[177,13]
[178,11]
[179,11]
[180,10]
[181,12]
[182,6]
[183,9]
[184,12]
[185,18]
[186,8]
[187,8]
[188,10]
[189,6]
[190,7]
[191,4]
[192,14]
[193,5]
[194,17]
[195,16]
[196,9]
[197,5]
[198,13]
[199,9]
[200,5]
[201,11]
[202,15]
[203,8]
[204,8]
[205,3]
[206,3]
[207,14]
[208,17]
[209,2]
[210,12]
[211,20]
[212,12]
[213,1]
[214,8]
[215,13]
[216,8]
[217,7]
[218,5]
[219,12]
[220,11]
[221,11]
[222,5]
[223,9]
[224,12]
[225,10]
[226,15]
[227,1]
[228,1]
[229,10]
[230,10]
[231,14]
[232,3]
[233,16]
[234,7]
[235,13]
[236,6]
[237,8]
[238,15]
[239,19]
[240,14]
[241,7]
[242,5]
[243,5]
[244,4]
[245,6]
[246,1]
[247,18]
[248,1]
[249,12]
[250,3]
[251,12]
[252,18]
[253,19]
[254,20]
[255,17]
[256,7]
[257,18]
[258,10]
[259,4]
[260,2]
[261,18]
[262,6]
[263,2]
[264,18]
[265,4]
[266,8]
[267,1]
[268,1]
[269,16]
[270,11]
[271,1]
[272,10]
[273,15]
[274,20]
[275,13]
[276,20]
[277,14]
[278,16]
[279,6]
[280,13]
[281,12]
[282,10]
[283,17]
[284,16]
[285,4]
[286,13]
[287,2]
[288,4]
[289,3]
[290,7]
[291,9]
[292,14]
[293,3]
[294,3]
[295,7]
[296,11]
[297,9]
[298,20]
[299,6]
[300,13]
[301,1]
[302,8]
[303,6]
[304,2]
[305,14]
[306,18]
[307,18]
[308,3]
[309,5]
[310,19]
[311,17]
[312,19]
[313,11]
[314,16]
[315,16]
[316,2]
[317,3]
[318,5]
[319,1]
[320,11]
[321,17]
[322,14]
[323,8]
[324,1]
[325,2]
[326,10]
[327,1]
[328,2]
[329,8]
[330,12]
[331,20]
[332,5]
[333,20]
[334,4]
[335,15]
[336,3]
[337,3]
[338,14]
[339,6]
[340,13]
[341,8]
[342,9]
[343,19]
[344,9]
[345,14]
[346,11]
[347,18]
[348,17]
[349,6]
[350,14]
[351,4]
[352,1]
[353,19]
[354,4]
[355,10]
[356,13]
[357,1]
[358,17]
[359,20]
[360,9]
[361,7]
[362,19]
[363,20]
[364,12]
[365,20]
[366,2]
[367,5]
[368,1]
[369,13]
[370,17]
[371,17]
[372,16]
[373,18]
[374,7]
[375,10]
[376,12]
[377,4]
[378,9]
[379,9]
[380,15]
[381,12]
[382,13]
[383,10]
[384,20]
[385,6]
[386,3]
[387,17]
[388,10]
[389,11]
[390,18]
[391,9]
[392,11]
[393,17]
[394,15]
[395,9]
[396,14]
[397,4]
[398,4]
[399,14]
[400,17]
[401,2]
[402,13]
[403,1]
[404,2]
[405,11]
[406,18]
[407,8]
[408,18]
[409,3]
[410,20]
[411,7]
[412,1]
[413,10]
[414,3]
[415,7]
[416,10]
[417,8]
[418,13]
[419,19]
[420,5]
[421,8]
[422,8]
[423,12]
[424,1]
[425,19]
[426,8]
[427,8]
[428,1]
[429,3]
[430,11]
[431,14]
[432,10]
[433,2]
[434,20]
[435,20]
[436,20]
[437,2]
[438,16]
[439,18]
[440,1]
[441,8]
[442,18]
[443,18]
[444,4]
[445,20]
[446,1]
[447,18]
[448,7]
[449,8]
[450,20]
[451,19]
[452,12]
[453,8]
[454,15]
[455,12]
[456,8]
[457,14]
[458,17]
[459,11]
[460,11]
[461,6]
[462,6]
[463,16]
[464,20]
[465,4]
[466,15]
[467,3]
[468,15]
[469,4]
[470,11]
[471,2]
[472,17]
[473,16]
[474,14]
[475,1]
[476,20]
[477,9]
[478,2]
[479,7]
[480,9]
[481,7]
[482,12]
[483,18]
[484,19]
[485,7]
[486,8]
[487,11]
[488,20]
[489,13]
[490,4]
[491,10]
[492,3]
[493,17]
[494,5]
[495,8]
[496,4]
[497,16]
[498,14]
[499,14]
[500,13]

{"sheet":"Normal","index":4,"n_rows":520,"n_cols":6,"rows_kept":520,"cut":false,"hidden":false,"merged":[]}
["Distribuição Normal"]
[]
["Característica"]
["Contínuo"]
["Simétrica (forma de sino)"]
["Ilimitada em ambas direções"]
["É ambos positivo e negativo"]
[]
["Parâmetros"]
["Média",100]
["Desvio Padrão",10]
[]
["Excel",null,"Exemplo"]
["=INV.NORM(ALEATÓRIO();B10;B11)",null,{"$f":"NORMINV(RAND(),B10,B11)","v":93.286522995239196}]
["Usando a Função UDF Snormal",null,{"$f":"Snormal(B10,B11)","v":97.863037850561909}]
["@RISK"]
["=RISKNORMAL(Mean,Stdev)",null,{"$f":"_xll.RiskNormal(B10,B11)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,96.205312462433128,null,{"$f":"70","v":70},"<=70",{"$f":"FREQUENCY(B21:B520,D21:D33)","v":0}]
[2,94.832638790515972,null,{"$f":"75","v":75}," 70- 75",2]
[3,106.28320115585369,null,{"$f":"80","v":80}," 75- 80",14]
[4,104.04933518227622,null,{"$f":"85","v":85}," 80- 85",19]
[5,115.03292947219984,null,{"$f":"90","v":90}," 85- 90",45]
[6,94.046674264904453,null,{"$f":"95","v":95}," 90- 95",72]
[7,116.13308809936095,null,{"$f":"100","v":100}," 95- 100",103]
[8,96.73045825031393,null,{"$f":"105","v":105}," 100- 105",85]
[9,90.190544805501588,null,{"$f":"110","v":110}," 105- 110",92]
[10,85.737505036605413,null,{"$f":"115","v":115}," 110- 115",41]
[11,98.203049903095163,null,{"$f":"120","v":120}," 115- 120",19]
[12,98.359883303948735,null,{"$f":"125","v":125}," 120- 125",5]
[13,120.73337040948569,null,{"$f":"130","v":130}," 125- 130",2]
[14,114.11607294001678,null,null,">130",1]
[15,81.132207707466506]
[16,110.95282169012887]
[17,105.66387772300502]
[18,104.58881523192179]
[19,99.008292137287242]
[20,108.21640862381938]
[21,102.92270385036919]
[22,106.22978144404057]
[23,98.686486739208647]
[24,101.27989081740718]
[25,108.73255650429827]
[26,109.49780929787751]
[27,105.90545190357263]
[28,106.51613927598402]
[29,79.837045501414508]
[30,89.141092289304652]
[31,76.580309547710499]
[32,97.617518962140366]
[33,76.341631498357202]
[34,101.2057099905453]
[35,118.56580407359235]
[36,81.082990899497887]
[37,103.22271077633756]
[38,110.47718369802679]
[39,106.77505137977344]
[40,96.49890941220167]
[41,99.904830655741506]
[42,98.088732576119241]
[43,97.693877009935804]
[44,88.005100826647237]
[45,94.297044890976508]
[46,105.78784593370226]
[47,113.03894680050934]
[48,85.341119365746792]
[49,109.77580701718789]
[50,90.991865918352971]
[51,106.45356212390938]
[52,89.782040768921888]
[53,88.896628863353996]
[54,102.46285991584196]
[55,125.98188012962979]
[56,91.26461561867356]
[57,109.82772519514559]
[58,107.26307833850255]
[59,109.01529864519682]
[60,101.31437354805342]
[61,91.792580825402851]
[62,95.3701334566301]
[63,99.979026583089492]
[64,99.846424608550052]
[65,101.06349094968613]
[66,102.65764295255832]
[67,110.35153987838454]
[68,88.715056063106829]
[69,101.94902994361527]
[70,100.90768073963615]
[71,110.56528023734346]
[72,102.42779193868066]
[73,104.1347483375485]
[74,105.55772791543156]
[75,89.396827726451619]
[76,96.081841220411548]
[77,117.89426177457113]
[78,84.714353364936898]
[79,107.16616828608007]
[80,101.19124523358994]
[81,95.918236776486708]
[82,108.11554398087509]
[83,94.780139430926837]
[84,107.09465337079321]
[85,109.05810533402997]
[86,105.29142270731252]
[87,86.147799933377456]
[88,94.237234240261742]
[89,109.77485890174512]
[90,116.79506789677698]
[91,93.970324901948587]
[92,116.24384219041262]
[93,85.713620300532085]
[94,83.56681115510348]
[95,109.0653823685778]
[96,102.34551103700903]
[97,95.543765780386835]
[98,110.70034631419729]
[99,104.24636623596689]
[100,107.27805606423745]
[101,95.369401072083306]
[102,92.981364306173901]
[103,109.32466321481144]
[104,89.917584566966553]
[105,110.81270173198509]
[106,96.102638470315213]
[107,100.31655241904726]
[108,105.73293880298198]
[109,104.67681331010269]
[110,98.232805118996737]
[111,113.36493365699425]
[112,100.11564504469673]
[113,79.55212566948893]
[114,114.86070201035734]
[115,91.333666829620213]
[116,96.571286256341693]
[117,91.63219186683267]
[118,106.63964957998763]
[119,131.233332929917]
[120,98.234953397365743]
[121,106.37120845712224]
[122,111.92307956705568]
[123,96.793294175413266]
[124,100.62721412440035]
[125,94.58964889863438]
[126,117.35896750105205]
[127,105.02535242357877]
[128,109.33071602756976]
[129,105.00419678782916]
[130,100.38020466771827]
[131,103.60304610809189]
[132,98.247039265905357]
[133,97.480291102422186]
[134,109.72016604111778]
[135,103.27147960724736]
[136,120.34712441190385]
[137,101.53925974312997]
[138,98.038807135645214]
[139,91.979725182479669]
[140,85.877402293607133]
[141,98.732563710922051]
[142,98.849059361192587]
[143,107.20900698410742]
[144,100.27224800096432]
[145,96.568401257763142]
[146,88.996563726964268]
[147,110.4960543760656]
[148,78.874167806425206]
[149,94.554732184256395]
[150,89.724821136549508]
[151,111.31194915327329]
[152,98.341265729570608]
[153,107.89574891775223]
[154,108.29396337254973]
[155,92.505655831370987]
[156,102.29837670459324]
[157,96.197016213360214]
[158,110.28939511961758]
[159,109.72654973668365]
[160,91.117148618888351]
[161,103.59107320567273]
[162,81.655679549755746]
[163,91.597415528910062]
[164,90.052705087615109]
[165,114.21585804439883]
[166,96.517699521451121]
[167,98.053015058140076]
[168,104.47286785467806]
[169,99.092843299902341]
[170,107.47082047965831]
[171,111.0592321167577]
[172,99.149853612059687]
[173,80.062771303034012]
[174,122.92527443733755]
[175,108.18032393130692]
[176,100.30781363795947]
[177,94.599213276342681]
[178,91.46442708446375]
[179,106.98719121192252]
[180,117.19736683217809]
[181,99.010442381315372]
[182,103.39020234285978]
[183,121.56478558566157]
[184,107.02891217380052]
[185,106.56925317389403]
[186,109.24159276284517]
[187,72.729550628006024]
[188,102.32869139190301]
[189,113.7558413642837]
[190,102.01205828463755]
[191,106.77786777626855]
[192,92.944048007712212]
[193,97.744645687244329]
[194,99.891503503456889]
[195,91.685642719687053]
[196,100.89783242751365]
[197,77.348511833946446]
[198,103.19029498580413]
[199,108.01185189070151]
[200,116.48996710260212]
[201,95.976745570474876]
[202,113.29359218236191]
[203,75.464233553848459]
[204,104.32061239787214]
[205,94.93863612290869]
[206,90.602447523364788]
[207,109.92547228461248]
[208,94.210992519994889]
[209,88.91813772660926]
[210,89.733857081121201]
[211,117.53036476617078]
[212,96.33102926075739]
[213,108.96786066977771]
[214,89.476059173090647]
[215,88.053226066588124]
[216,99.858204211266923]
[217,89.936634520614604]
[218,96.260684566427727]
[219,86.040134115381221]
[220,92.975720720649036]
[221,86.974583646439484]
[222,103.028183632355]
[223,93.895442079978537]
[224,101.02343132530046]
[225,125.51082746592797]
[226,99.443265253092278]
[227,105.07016875474362]
[228,94.27025481860862]
[229,108.57465754681489]
[230,94.331987377836839]
[231,96.575319157747472]
[232,104.99696298230093]
[233,78.040642504191354]
[234,90.804904187535413]
[235,95.624283234226297]
[236,99.341924743891667]
[237,84.612327178500635]
[238,98.27484627410945]
[239,88.821580570019265]
[240,108.02981946855348]
[241,83.907599281851304]
[242,97.559580426084622]
[243,117.41296951088151]
[244,96.41683973186079]
[245,94.654386852722666]
[246,113.28389828016017]
[247,98.397392156246127]
[248,99.623960524237106]
[249,97.79466798408194]
[250,102.87061597507289]
[251,90.208761697311928]
[252,99.808547751447321]
[253,105.36821606293607]
[254,91.103560915278635]
[255,83.950631582773241]
[256,82.301284647394212]
[257,86.251078392223889]
[258,112.59227263932105]
[259,86.000775708248412]
[260,98.415736890905336]
[261,102.06512326797339]
[262,87.962781767066147]
[263,92.582382470673494]
[264,96.344681895772879]
[265,109.0502802412619]
[266,104.30976668570621]
[267,98.358004196573134]
[268,93.397351361793866]
[269,85.015657824179854]
[270,95.298625135687701]
[271,96.718811196898926]
[272,109.87526267514052]
[273,92.634186154664846]
[274,108.49362488523995]
[275,92.514349467081701]
[276,90.215899434213469]
[277,92.431770295735262]
[278,108.09236610868052]
[279,107.1135189070375]
[280,101.52397695948135]
[281,100.10731789428388]
[282,107.00002201742699]
[283,112.46855338646037]
[284,119.15466067590243]
[285,75.816153411851928]
[286,107.19114659833032]
[287,87.78604502152632]
[288,81.222556592871015]
[289,111.96162674414327]
[290,107.60328646147617]
[291,114.97901894343117]
[292,98.097355852088882]
[293,106.02367180831436]
[294,100.33373386473873]
[295,98.615614736731644]
[296,81.854167900069697]
[297,114.22600655068645]
[298,108.79158805241541]
[299,102.13562631572371]
[300,88.959678616679554]
[301,120.61705013501556]
[302,101.11637685677026]
[303,91.682692956883301]
[304,105.76591890246895]
[305,103.40129090391362]
[306,86.315732244876386]
[307,107.85957567950319]
[308,97.586010563757426]
[309,78.01146712377448]
[310,89.915529365568403]
[311,96.837081895722633]
[312,109.64886537462696]
[313,89.636867386689516]
[314,103.49417785441737]
[315,96.911907989955552]
[316,106.80950401829547]
[317,86.014267713471284]
[318,98.060727290368305]
[319,103.52616469682141]
[320,90.155151292602341]
[321,100.51787722072206]
[322,100.65868534040789]
[323,102.51374552312744]
[324,95.450023355006053]
[325,104.41776879524895]
[326,113.22265838955448]
[327,99.162149267610872]
[328,109.28443377947779]
[329,114.97097477709187]
[330,97.401646268259199]
[331,78.03316160340097]
[332,113.79706661255679]
[333,109.65942825824087]
[334,106.64958044566418]
[335,88.214704041096439]
[336,107.93298829022393]
[337,99.091756608797255]
[338,96.105645104963031]
[339,102.65120803991613]
[340,97.872791555972952]
[341,100.29881930908826]
[342,107.46090562115684]
[343,114.45424681000566]
[344,108.20546406778593]
[345,101.35660970846939]
[346,102.71802955357262]
[347,104.39386232131473]
[348,97.640227977887164]
[349,104.1182725301162]
[350,107.80406635221607]
[351,97.472925603588862]
[352,82.387790275561954]
[353,92.174149109135982]
[354,106.22591061622317]
[355,91.530269826484428]
[356,106.10436071755034]
[357,109.0688529529067]
[358,99.854084372979585]
[359,101.08319757211459]
[360,94.216254786337572]
[361,111.64251415223028]
[362,99.169648200215065]
[363,106.78575135057864]
[364,105.08526765023542]
[365,99.588262915973303]
[366,98.419001173492916]
[367,110.14527812328126]
[368,95.628739019665389]
[369,84.479380464385201]
[370,103.86690201650784]
[371,110.03486625887334]
[372,95.577709178924906]
[373,113.3365241295829]
[374,115.4786844236308]
[375,109.5162045146712]
[376,95.022811186834247]
[377,93.261789818340134]
[378,101.20944792160358]
[379,98.037271008866611]
[380,103.07809042900547]
[381,115.05168090127704]
[382,103.74206349401642]
[383,96.017803708014227]
[384,106.9462040509887]
[385,96.380253711793699]
[386,110.90012002454255]
[387,96.07991195210117]
[388,93.665320658920876]
[389,92.806468890216465]
[390,102.28454019183691]
[391,85.329577111245484]
[392,94.548264021687388]
[393,118.44220869976631]
[394,94.411856926560617]
[395,85.635898884373816]
[396,89.009817855446627]
[397,104.95276062380546]
[398,105.57199441155183]
[399,114.93329099589899]
[400,101.75479281788708]
[401,106.09723362086122]
[402,99.988279837228276]
[403,88.21642370863195]
[404,88.382665518619461]
[405,119.16967914085259]
[406,116.08308504566956]
[407,79.127259654327673]
[408,92.554590196870009]
[409,86.938032821346283]
[410,100.05858148478414]
[411,104.22385540316907]
[412,105.34166802128964]
[413,90.639577931012965]
[414,91.950148572844427]
[415,104.89741712417664]
[416,100.10702777359782]
[417,103.70173781955894]
[418,102.60784861110442]
[419,74.105052914294049]
[420,97.720536438099444]
[421,94.447953379609885]
[422,91.067044257726508]
[423,98.451185227214481]
[424,94.787385032024076]
[425,92.896037440255029]
[426,107.39800540058846]
[427,92.448333210562737]
[428,104.32139418797087]
[429,102.15691838858172]
[430,94.380873965721776]
[431,105.24626226469043]
[432,104.73892281398601]
[433,91.996222969613271]
[434,107.32724062311502]
[435,86.074066171953206]
[436,93.896002777834553]
[437,105.92068245019483]
[438,106.83656530177026]
[439,99.54450199853828]
[440,94.976417563384985]
[441,91.911233164149564]
[442,104.61184776795658]
[443,101.98256054400154]
[444,98.03376573864864]
[445,93.985377220466447]
[446,111.13830095707861]
[447,91.565431632497834]
[448,96.620559608088698]
[449,97.980221822531007]
[450,105.46938224234931]
[451,97.761840962907996]
[452,84.849217462269195]
[453,96.459172301025433]
[454,110.93499353876723]
[455,111.57728722363042]
[456,98.521651288428629]
[457,102.40998071359446]
[458,111.90719912435054]
[459,95.176616935078769]
[460,105.0560476689587]
[461,97.885007156107818]
[462,91.277476862983889]
[463,94.16554073171433]
[464,86.776423235036049]
[465,108.63005685729566]
[466,94.115234092375786]
[467,99.800640254260173]
[468,102.70773166629549]
[469,107.75104317868332]
[470,83.333276624639126]
[471,101.37346889853411]
[472,89.691026887597431]
[473,85.58163947093287]
[474,102.22898857735821]
[475,110.50701382902213]
[476,99.779435095871662]
[477,94.764979253174545]
[478,102.01263719532226]
[479,119.31958468395277]
[480,90.257992209845511]
[481,99.107336569895566]
[482,98.185821321883779]
[483,108.19799234241759]
[484,99.062711728672042]
[485,78.804657285950384]
[486,97.216569768295727]
[487,85.959523149670346]
[488,97.14983166863739]
[489,116.3689817834243]
[490,83.605085557153998]
[491,105.72517692353523]
[492,87.136166051564871]
[493,76.638556536766657]
[494,112.05137705940416]
[495,111.72124183342584]
[496,84.232671047027637]
[497,92.16485606793286]
[498,83.889741233200184]
[499,99.7393963195358]
[500,102.99101308880984]

{"sheet":"Triangular","index":5,"n_rows":521,"n_cols":7,"rows_kept":521,"cut":false,"hidden":false,"merged":[[14,4,15,4],[14,6,15,6]]}
["Distribuição Triangular"]
[]
["Características"]
["Contínuo"]
["POde ser simétrica ou distorcida numa direção"]
["Limitado em ambas direções"]
["Não necessariamente positivo (depende dos limites)"]
[]
["Parâmetros"]
["Min",50]
["Mais Provável",85]
["Max",100]
[]
["Excel"]
["Não existe maneira fácil de fazer isso exceto escrevendo uma macro.",null,null,null,{"$f":"Striangular(B10,B12,B11)","v":83.479222311073755},null,{"$f":"DesvTriangular(B10,B12,B11)","v":69.218493514171556}]
["Usamos a Função UDF chamada Striangular"]
["@RISK",null,"Exemplo"]
["=RISKTRIANG(Min,MostLikely,Max)",null,{"$f":"_xll.RiskTriang(B10,B11,B12)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,83.066238403320313,null,{"$f":"55","v":55},"<=55",{"$f":"FREQUENCY(B22:B521,D22:D30)","v":7}]
[2,93.312110900878906,null,{"$f":"60","v":60}," 55- 60",15]
[3,75.453147888183594,null,{"$f":"65","v":65}," 60- 65",29]
[4,82.721664428710938,null,{"$f":"70","v":70}," 65- 70",42]
[5,90.792236328125,null,{"$f":"75","v":75}," 70- 75",54]
[6,80.467155456542969,null,{"$f":"80","v":80}," 75- 80",91]
[7,76.349876403808594,null,{"$f":"85","v":85}," 80- 85",106]
[8,64.829994201660156,null,{"$f":"90","v":90}," 85- 90",75]
[9,68.917030334472656,null,{"$f":"95","v":95}," 90- 95",61]
[10,85.061759948730469,null,null,">95",20]
[11,78.804458618164063]
[12,77.263786315917969]
[13,73.188323974609375]
[14,83.978599548339844]
[15,82.465438842773438]
[16,58.389884948730469]
[17,78.398414611816406]
[18,92.932975769042969]
[19,59.055580139160156]
[20,95.424781799316406]
[21,68.539039611816406]
[22,71.244194030761719]
[23,80.804702758789063]
[24,94.17584228515625]
[25,96.40533447265625]
[26,66.959335327148438]
[27,74.890693664550781]
[28,71.076927185058594]
[29,88.3797607421875]
[30,64.589370727539063]
[31,79.049179077148438]
[32,90.100059509277344]
[33,70.456428527832031]
[34,65.066780090332031]
[35,92.589202880859375]
[36,80.615623474121094]
[37,85.229293823242188]
[38,85.503005981445313]
[39,84.692123413085938]
[40,87.268280029296875]
[41,79.446243286132812]
[42,75.122901916503906]
[43,79.566200256347656]
[44,62.048213958740234]
[45,74.128036499023438]
[46,73.587936401367188]
[47,83.143150329589844]
[48,84.960487365722656]
[49,76.749763488769531]
[50,70.860610961914062]
[51,85.751991271972656]
[52,56.171852111816406]
[53,90.468376159667969]
[54,81.670394897460938]
[55,69.830429077148437]
[56,71.738204956054688]
[57,84.119873046875]
[58,69.353385925292969]
[59,72.99188232421875]
[60,81.558433532714844]
[61,86.809257507324219]
[62,67.314285278320312]
[63,77.439651489257813]
[64,67.972511291503906]
[65,92.331375122070313]
[66,77.905303955078125]
[67,90.310539245605469]
[68,89.424041748046875]
[69,76.177169799804688]
[70,57.830612182617188]
[71,75.453086853027344]
[72,63.170894622802734]
[73,67.646461486816406]
[74,84.392707824707031]
[75,67.845916748046875]
[76,76.398063659667969]
[77,72.163978576660156]
[78,83.287971496582031]
[79,81.741897583007813]
[80,54.892219543457031]
[81,77.568344116210937]
[82,91.6422119140625]
[83,86.437187194824219]
[84,84.495468139648437]
[85,91.526748657226563]
[86,70.121116638183594]
[87,80.041191101074219]
[88,92.663063049316406]
[89,84.765350341796875]
[90,90.210777282714844]
[91,80.476211547851562]
[92,77.449760437011719]
[93,98.421066284179688]
[94,57.572246551513672]
[95,83.957435607910156]
[96,58.975833892822266]
[97,66.215873718261719]
[98,73.157295227050781]
[99,63.457572937011719]
[100,85.311363220214844]
[101,90.745979309082031]
[102,91.189445495605469]
[103,89.917396545410156]
[104,94.563102722167969]
[105,76.675277709960938]
[106,80.666152954101563]
[107,84.400772094726563]
[108,71.316947937011719]
[109,79.8565673828125]
[110,79.421821594238281]
[111,87.888397216796875]
[112,90.32281494140625]
[113,92.679283142089844]
[114,86.818275451660156]
[115,70.8739013671875]
[116,80.781356811523438]
[117,76.4085693359375]
[118,62.744171142578125]
[119,86.153587341308594]
[120,87.440704345703125]
[121,67.987937927246094]
[122,85.867263793945313]
[123,88.437004089355469]
[124,62.463344573974609]
[125,56.216636657714844]
[126,84.773330688476563]
[127,93.870491027832031]
[128,77.706451416015625]
[129,95.450706481933594]
[130,79.455612182617188]
[131,83.986717224121094]
[132,91.412841796875]
[133,77.823936462402344]
[134,88.389945983886719]
[135,77.143821716308594]
[136,90.687248229980469]
[137,70.008125305175781]
[138,85.6839599609375]
[139,70.184249877929687]
[140,78.031852722167969]
[141,74.086700439453125]
[142,84.597923278808594]
[143,75.133880615234375]
[144,87.719306945800781]
[145,79.136589050292969]
[146,84.801925659179688]
[147,87.923652648925781]
[148,85.790313720703125]
[149,94.196189880371094]
[150,72.2213134765625]
[151,81.48651123046875]
[152,85.340415954589844]
[153,86.075050354003906]
[154,92.402809143066406]
[155,75.729705810546875]
[156,72.061454772949219]
[157,89.191299438476563]
[158,90.5257568359375]
[159,79.771217346191406]
[160,83.151473999023438]
[161,98.719276428222656]
[162,66.415809631347656]
[163,93.940452575683594]
[164,81.301551818847656]
[165,78.611801147460938]
[166,78.936614990234375]
[167,77.950859069824219]
[168,80.81365966796875]
[169,71.090011596679688]
[170,80.336204528808594]
[171,84.106971740722656]
[172,96.385818481445313]
[173,79.517578125]
[174,79.0777587890625]
[175,87.537376403808594]
[176,82.351158142089844]
[177,83.764762878417969]
[178,79.320198059082031]
[179,95.409431457519531]
[180,80.452659606933594]
[181,64.578117370605469]
[182,61.928394317626953]
[183,85.845527648925781]
[184,79.950935363769531]
[185,91.68499755859375]
[186,85.565315246582031]
[187,80.872894287109375]
[188,88.115631103515625]
[189,54.303401947021484]
[190,84.482704162597656]
[191,84.313896179199219]
[192,77.340812683105469]
[193,77.423614501953125]
[194,94.071090698242188]
[195,64.333267211914062]
[196,75.065658569335938]
[197,91.327804565429688]
[198,72.041496276855469]
[199,90.448616027832031]
[200,74.453659057617187]
[201,84.650688171386719]
[202,92.181541442871094]
[203,84.752685546875]
[204,83.48681640625]
[205,80.261383056640625]
[206,90.347419738769531]
[207,88.326904296875]
[208,71.176467895507813]
[209,93.430145263671875]
[210,66.17156982421875]
[211,71.448921203613281]
[212,85.489959716796875]
[213,93.495368957519531]
[214,71.763717651367188]
[215,72.505767822265625]
[216,85.049102783203125]
[217,85.768692016601563]
[218,91.854866027832031]
[219,75.335556030273438]
[220,51.347862243652344]
[221,81.504127502441406]
[222,90.080963134765625]
[223,79.431243896484375]
[224,82.846504211425781]
[225,96.7958984375]
[226,65.790863037109375]
[227,93.266197204589844]
[228,80.978378295898438]
[229,78.257881164550781]
[230,78.586715698242188]
[231,77.588462829589844]
[232,80.485313415527344]
[233,70.607315063476562]
[234,63.738269805908203]
[235,70.778358459472656]
[236,88.71295166015625]
[237,74.586692810058594]
[238,60.675704956054688]
[239,75.613441467285156]
[240,77.925178527832031]
[241,79.551261901855469]
[242,74.349380493164063]
[243,88.363487243652344]
[244,75.701805114746094]
[245,95.177719116210938]
[246,84.069648742675781]
[247,81.870628356933594]
[248,75.105316162109375]
[249,86.454727172851563]
[250,81.576011657714844]
[251,76.198356628417969]
[252,83.965599060058594]
[253,60.365642547607422]
[254,85.777046203613281]
[255,85.603141784667969]
[256,78.921401977539063]
[257,69.396347045898437]
[258,85.991973876953125]
[259,67.157211303710938]
[260,76.780860900878906]
[261,84.621963500976563]
[262,73.974044799804687]
[263,84.077789306640625]
[264,76.208946228027344]
[265,78.719924926757812]
[266,95.202438354492188]
[267,86.061515808105469]
[268,84.789276123046875]
[269,81.696662902832031]
[270,92.579719543457031]
[271,90.09295654296875]
[272,73.181243896484375]
[273,85.708892822265625]
[274,68.720222473144531]
[275,73.430397033691406]
[276,70.448402404785156]
[277,78.472373962402344]
[278,80.303390502929687]
[279,88.034149169921875]
[280,69.693435668945313]
[281,70.900466918945313]
[282,77.469970703125]
[283,82.962501525878906]
[284,80.186363220214844]
[285,62.325183868408203]
[286,76.07354736328125]
[287,86.280899047851563]
[288,65.436737060546875]
[289,79.756431579589844]
[290,76.343643188476562]
[291,68.407432556152344]
[292,87.827949523925781]
[293,95.752708435058594]
[294,90.987030029296875]
[295,89.74005126953125]
[296,94.240867614746094]
[297,84.174789428710938]
[298,80.528587341308594]
[299,84.2781982421875]
[300,71.118576049804687]
[301,79.715263366699219]
[302,79.278411865234375]
[303,87.740364074707031]
[304,90.138175964355469]
[305,92.4368896484375]
[306,86.68212890625]
[307,70.671279907226562]
[308,80.644309997558594]
[309,76.248703002929688]
[310,62.409503936767578]
[311,86.023918151855469]
[312,87.297889709472656]
[313,67.752403259277344]
[314,85.740203857421875]
[315,88.282035827636719]
[316,62.120925903320312]
[317,72.248420715332031]
[318,84.652076721191406]
[319,93.58294677734375]
[320,84.985610961914063]
[321,77.636276245117187]
[322,94.510574340820313]
[323,76.113510131835938]
[324,75.298149108886719]
[325,91.622123718261719]
[326,81.020965576171875]
[327,90.71502685546875]
[328,82.77886962890625]
[329,84.819244384765625]
[330,68.271293640136719]
[331,84.920745849609375]
[332,91.924629211425781]
[333,87.61724853515625]
[334,76.9041748046875]
[335,74.965850830078125]
[336,87.573287963867188]
[337,69.384506225585937]
[338,84.680770874023437]
[339,80.602760314941406]
[340,78.384552001953125]
[341,84.615341186523438]
[342,54.539264678955078]
[343,72.764419555664062]
[344,85.217880249023437]
[345,78.711929321289063]
[346,83.795631408691406]
[347,63.741756439208984]
[348,53.677764892578125]
[349,81.689422607421875]
[350,82.670707702636719]
[351,70.325942993164063]
[352,83.024261474609375]
[353,85.702011108398438]
[354,90.656486511230469]
[355,84.512931823730469]
[356,72.507896423339844]
[357,78.464309692382813]
[358,78.790786743164062]
[359,77.79986572265625]
[360,80.6767578125]
[361,96.511665344238281]
[362,64.158012390136719]
[363,71.058242797851563]
[364,88.937492370605469]
[365,62.306552886962891]
[366,61.210704803466797]
[367,75.84100341796875]
[368,78.134048461914063]
[369,79.74871826171875]
[370,74.588645935058594]
[371,88.581146240234375]
[372,64.405838012695312]
[373,95.729621887207031]
[374,84.241065979003906]
[375,80.304977416992188]
[376,81.586311340332031]
[377,94.900062561035156]
[378,79.994987487792969]
[379,82.461860656738281]
[380,90.09503173828125]
[381,87.829643249511719]
[382,78.721595764160156]
[383,85.778488159179688]
[384,69.580421447753906]
[385,69.695869445800781]
[386,86.172256469726563]
[387,91.753326416015625]
[388,66.252998352050781]
[389,84.790657043457031]
[390,61.031787872314453]
[391,84.249160766601563]
[392,65.29229736328125]
[393,78.923057556152344]
[394,95.757553100585938]
[395,79.045173645019531]
[396,84.957160949707031]
[397,81.880836486816406]
[398,92.925933837890625]
[399,82.67919921875]
[400,59.182357788085938]
[401,85.88555908203125]
[402,93.368659973144531]
[403,59.794338226318359]
[404,96.131599426269531]
[405,68.910888671875]
[406,80.495979309082031]
[407,88.245712280273437]
[408,94.712966918945313]
[409,97.363044738769531]
[410,67.365043640136719]
[411,83.139640808105469]
[412,80.379692077636719]
[413,62.791378021240234]
[414,65.059059143066406]
[415,86.46502685546875]
[416,90.406219482421875]
[417,83.820243835449219]
[418,88.055755615234375]
[419,82.587738037109375]
[420,69.427391052246094]
[421,64.7061767578125]
[422,65.328536987304688]
[423,63.374862670898438]
[424,68.631103515625]
[425,91.782203674316406]
[426,58.442001342773438]
[427,67.727592468261719]
[428,79.504287719726563]
[429,54.719043731689453]
[430,98.774917602539062]
[431,73.207229614257813]
[432,64.056289672851563]
[433,67.059921264648437]
[434,53.264354705810547]
[435,79.185798645019531]
[436,58.851348876953125]
[437,83.36920166015625]
[438,82.299667358398438]
[439,70.8206787109375]
[440,56.931137084960937]
[441,77.196632385253906]
[442,70.366844177246094]
[443,60.203807830810547]
[444,73.904518127441406]
[445,80.323280334472656]
[446,68.440147399902344]
[447,68.122520446777344]
[448,93.404609680175781]
[449,93.553619384765625]
[450,78.617485046386719]
[451,83.262962341308594]
[452,90.2738037109375]
[453,76.935089111328125]
[454,87.523895263671875]
[455,76.23193359375]
[456,89.627578735351563]
[457,68.752395629882812]
[458,84.973030090332031]
[459,78.696601867675781]
[460,77.149810791015625]
[461,73.054214477539063]
[462,83.887214660644531]
[463,82.369781494140625]
[464,58.011768341064453]
[465,85.583221435546875]
[466,92.747367858886719]
[467,58.7064208984375]
[468,95.142990112304688]
[469,68.371017456054687]
[470,80.164176940917969]
[471,80.703872680664063]
[472,93.951972961425781]
[473,96.052909851074219]
[474,66.775497436523438]
[475,82.834564208984375]
[476,70.929283142089844]
[477,88.265953063964844]
[478,64.375259399414063]
[479,86.150039672851563]
[480,89.966720581054687]
[481,70.304275512695313]
[482,76.183387756347656]
[483,68.177330017089844]
[484,87.680648803710937]
[485,85.139595031738281]
[486,85.411628723144531]
[487,84.602622985839844]
[488,87.164321899414063]
[489,79.340751647949219]
[490,74.999168395996094]
[491,79.461135864257813]
[492,61.788032531738281]
[493,82.26025390625]
[494,73.456108093261719]
[495,83.049453735351563]
[496,84.871673583984375]
[497,86.259994506835938]
[498,97.985275268554687]
[499,78.838920593261719]
[500,57.630142211914063]

{"sheet":"Binomial","index":6,"n_rows":520,"n_cols":6,"rows_kept":520,"cut":false,"hidden":false,"merged":[]}
["Distribuição Binomial"]
[]
["Características"]
["Discreta"]
["Pode ser simétrica ou distorcida"]
["Limitada abaixo por 0, limitada acima por Ntrials"]
["Não negativo"]
[]
["Parâmetros"]
["NTrials",170]
["Psucesso",0.8]
[]
["Excel",null,"Exemplo"]
["=CRIT.BINOM(B10;B11;ALEATÓRIO())",null,{"$f":"CRITBINOM(B10,B11,RAND())","v":140}]
[]
["@RISK"]
["=RISKBINOMIAL(NTrials,PSuccess)",null,{"$f":"_xll.RiskBinomial(B10,B11)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,129,null,117,117,{"$f":"FREQUENCY(B21:B520,D21:D57)","v":2}]
[2,138,null,118,118,0]
[3,135,null,119,119,0]
[4,139,null,120,120,1]
[5,143,null,121,121,0]
[6,137,null,122,122,2]
[7,137,null,123,123,3]
[8,134,null,124,124,3]
[9,128,null,125,125,3]
[10,130,null,126,126,4]
[11,137,null,127,127,10]
[12,140,null,128,128,16]
[13,128,null,129,129,21]
[14,139,null,130,130,18]
[15,127,null,131,131,28]
[16,140,null,132,132,25]
[17,141,null,133,133,34]
[18,130,null,134,134,34]
[19,143,null,135,135,38]
[20,142,null,136,136,38]
[21,140,null,137,137,28]
[22,129,null,138,138,33]
[23,127,null,139,139,31]
[24,136,null,140,140,30]
[25,143,null,141,141,23]
[26,134,null,142,142,20]
[27,125,null,143,143,17]
[28,144,null,144,144,17]
[29,131,null,145,145,10]
[30,132,null,146,146,5]
[31,136,null,147,147,3]
[32,143,null,148,148,2]
[33,145,null,149,149,0]
[34,130,null,150,150,0]
[35,135,null,151,151,1]
[36,133,null,152,152,0]
[37,141,null,153,153,0]
[38,131,null,null,">=154",0]
[39,136]
[40,143]
[41,133]
[42,131]
[43,136]
[44,129]
[45,133]
[46,133]
[47,133]
[48,134]
[49,128]
[50,143]
[51,142]
[52,135]
[53,139]
[54,138]
[55,147]
[56,128]
[57,130]
[58,144]
[59,139]
[60,122]
[61,142]
[62,137]
[63,132]
[64,133]
[65,138]
[66,132]
[67,133]
[68,134]
[69,137]
[70,144]
[71,132]
[72,145]
[73,139]
[74,132]
[75,138]
[76,135]
[77,145]
[78,138]
[79,144]
[80,138]
[81,140]
[82,133]
[83,140]
[84,140]
[85,138]
[86,148]
[87,144]
[88,134]
[89,140]
[90,133]
[91,130]
[92,141]
[93,128]
[94,135]
[95,138]
[96,129]
[97,141]
[98,126]
[99,136]
[100,143]
[101,136]
[102,136]
[103,130]
[104,136]
[105,138]
[106,140]
[107,137]
[108,132]
[109,143]
[110,143]
[111,142]
[112,148]
[113,135]
[114,137]
[115,139]
[116,133]
[117,128]
[118,128]
[119,134]
[120,135]
[121,136]
[122,134]
[123,141]
[124,129]
[125,140]
[126,135]
[127,129]
[128,131]
[129,137]
[130,129]
[131,131]
[132,135]
[133,135]
[134,129]
[135,134]
[136,141]
[137,141]
[138,134]
[139,137]
[140,140]
[141,134]
[142,132]
[143,141]
[144,133]
[145,138]
[146,130]
[147,138]
[148,142]
[149,139]
[150,142]
[151,137]
[152,120]
[153,139]
[154,142]
[155,123]
[156,144]
[157,131]
[158,140]
[159,127]
[160,132]
[161,132]
[162,135]
[163,142]
[164,140]
[165,134]
[166,131]
[167,140]
[168,143]
[169,133]
[170,135]
[171,132]
[172,141]
[173,140]
[174,133]
[175,133]
[176,134]
[177,128]
[178,132]
[179,134]
[180,138]
[181,131]
[182,132]
[183,136]
[184,134]
[185,134]
[186,132]
[187,139]
[188,132]
[189,141]
[190,140]
[191,147]
[192,140]
[193,131]
[194,146]
[195,140]
[196,128]
[197,133]
[198,139]
[199,139]
[200,136]
[201,136]
[202,151]
[203,131]
[204,135]
[205,144]
[206,134]
[207,136]
[208,144]
[209,133]
[210,136]
[211,133]
[212,132]
[213,130]
[214,136]
[215,144]
[216,135]
[217,128]
[218,133]
[219,135]
[220,134]
[221,137]
[222,142]
[223,139]
[224,129]
[225,130]
[226,133]
[227,140]
[228,135]
[229,145]
[230,133]
[231,135]
[232,137]
[233,143]
[234,128]
[235,142]
[236,136]
[237,134]
[238,135]
[239,135]
[240,136]
[241,132]
[242,129]
[243,132]
[244,140]
[245,134]
[246,126]
[247,134]
[248,144]
[249,117]
[250,141]
[251,134]
[252,142]
[253,136]
[254,131]
[255,142]
[256,138]
[257,127]
[258,142]
[259,139]
[260,145]
[261,131]
[262,141]
[263,129]
[264,141]
[265,137]
[266,130]
[267,137]
[268,140]
[269,128]
[270,139]
[271,141]
[272,137]
[273,138]
[274,130]
[275,143]
[276,142]
[277,140]
[278,129]
[279,127]
[280,133]
[281,139]
[282,131]
[283,133]
[284,132]
[285,135]
[286,136]
[287,140]
[288,146]
[289,115]
[290,131]
[291,134]
[292,133]
[293,141]
[294,130]
[295,136]
[296,139]
[297,127]
[298,144]
[299,139]
[300,134]
[301,136]
[302,137]
[303,136]
[304,130]
[305,141]
[306,139]
[307,141]
[308,135]
[309,138]
[310,138]
[311,146]
[312,137]
[313,138]
[314,136]
[315,145]
[316,133]
[317,130]
[318,141]
[319,136]
[320,126]
[321,135]
[322,146]
[323,128]
[324,134]
[325,137]
[326,144]
[327,132]
[328,144]
[329,136]
[330,123]
[331,135]
[332,135]
[333,145]
[334,137]
[335,144]
[336,138]
[337,140]
[338,133]
[339,140]
[340,124]
[341,142]
[342,132]
[343,131]
[344,138]
[345,137]
[346,127]
[347,143]
[348,141]
[349,127]
[350,134]
[351,138]
[352,128]
[353,138]
[354,141]
[355,133]
[356,131]
[357,139]
[358,140]
[359,135]
[360,140]
[361,131]
[362,134]
[363,130]
[364,139]
[365,143]
[366,143]
[367,142]
[368,146]
[369,135]
[370,134]
[371,136]
[372,128]
[373,134]
[374,133]
[375,138]
[376,139]
[377,139]
[378,135]
[379,142]
[380,131]
[381,124]
[382,139]
[383,134]
[384,135]
[385,140]
[386,130]
[387,132]
[388,136]
[389,135]
[390,129]
[391,134]
[392,141]
[393,141]
[394,131]
[395,134]
[396,137]
[397,129]
[398,136]
[399,129]
[400,137]
[401,142]
[402,143]
[403,135]
[404,138]
[405,136]
[406,142]
[407,137]
[408,147]
[409,138]
[410,135]
[411,137]
[412,136]
[413,139]
[414,125]
[415,133]
[416,135]
[417,136]
[418,131]
[419,138]
[420,137]
[421,130]
[422,131]
[423,140]
[424,143]
[425,133]
[426,135]
[427,124]
[428,138]
[429,137]
[430,137]
[431,136]
[432,138]
[433,134]
[434,135]
[435,130]
[436,135]
[437,145]
[438,144]
[439,133]
[440,127]
[441,129]
[442,144]
[443,136]
[444,125]
[445,138]
[446,137]
[447,132]
[448,122]
[449,135]
[450,132]
[451,141]
[452,129]
[453,133]
[454,145]
[455,145]
[456,139]
[457,139]
[458,132]
[459,144]
[460,131]
[461,139]
[462,129]
[463,139]
[464,131]
[465,136]
[466,139]
[467,136]
[468,123]
[469,142]
[470,132]
[471,131]
[472,138]
[473,133]
[474,136]
[475,138]
[476,129]
[477,134]
[478,138]
[479,138]
[480,128]
[481,129]
[482,133]
[483,139]
[484,131]
[485,139]
[486,126]
[487,138]
[488,140]
[489,131]
[490,133]
[491,129]
[492,136]
[493,135]
[494,135]
[495,134]
[496,136]
[497,131]
[498,127]
[499,131]
[500,140]

{"sheet":"Poisson","index":7,"n_rows":519,"n_cols":6,"rows_kept":519,"cut":false,"hidden":false,"merged":[]}
["Distribuição de Poisson"]
[]
["Características"]
["Discreta"]
["Distorcida à direita"]
["Limitada abaixo por 0, não limitada acima"]
["Não negativa"]
[]
["Parâmetro"]
["Taxa",10]
[]
["Excel"]
["Não há um modo fácil de fazer isso exceto escrevendo uma macro."]
[]
["@RISK",null,"Exemplo"]
["=RISKPOISSON(Rate)",null,{"$f":"_xll.RiskPoisson(B10)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,6,null,{"$f":"0","v":0},"0",{"$f":"FREQUENCY(B20:B519,D20:D45)","v":0}]
[2,10,null,{"$f":"1","v":1},"1",0]
[3,9,null,{"$f":"2","v":2},"2",3]
[4,11,null,{"$f":"3","v":3},"3",10]
[5,12,null,{"$f":"4","v":4},"4",10]
[6,10,null,{"$f":"5","v":5},"5",21]
[7,14,null,{"$f":"6","v":6},"6",35]
[8,12,null,{"$f":"7","v":7},"7",36]
[9,9,null,{"$f":"8","v":8},"8",58]
[10,10,null,{"$f":"9","v":9},"9",67]
[11,12,null,{"$f":"10","v":10},"10",44]
[12,10,null,{"$f":"11","v":11},"11",70]
[13,13,null,{"$f":"12","v":12},"12",36]
[14,8,null,{"$f":"13","v":13},"13",46]
[15,9,null,{"$f":"14","v":14},"14",23]
[16,10,null,{"$f":"15","v":15},"15",13]
[17,12,null,{"$f":"16","v":16},"16",14]
[18,9,null,{"$f":"17","v":17},"17",4]
[19,6,null,{"$f":"18","v":18},"18",4]
[20,11,null,{"$f":"19","v":19},"19",2]
[21,4,null,{"$f":"20","v":20},"20",4]
[22,9,null,{"$f":"21","v":21},"21",0]
[23,8,null,{"$f":"22","v":22},"22",0]
[24,13,null,{"$f":"23","v":23},"23",0]
[25,9,null,{"$f":"24","v":24},"24",0]
[26,11,null,{"$f":"25","v":25},"25",0]
[27,11,null,null,">=25",0]
[28,7]
[29,14]
[30,18]
[31,9]
[32,11]
[33,7]
[34,12]
[35,7]
[36,13]
[37,15]
[38,10]
[39,7]
[40,12]
[41,9]
[42,6]
[43,11]
[44,4]
[45,9]
[46,8]
[47,13]
[48,9]
[49,11]
[50,11]
[51,10]
[52,12]
[53,10]
[54,8]
[55,11]
[56,14]
[57,8]
[58,9]
[59,8]
[60,5]
[61,3]
[62,11]
[63,12]
[64,16]
[65,6]
[66,9]
[67,6]
[68,16]
[69,9]
[70,8]
[71,13]
[72,12]
[73,10]
[74,9]
[75,12]
[76,6]
[77,13]
[78,9]
[79,16]
[80,4]
[81,9]
[82,11]
[83,7]
[84,5]
[85,3]
[86,11]
[87,12]
[88,16]
[89,6]
[90,9]
[91,6]
[92,16]
[93,9]
[94,8]
[95,13]
[96,12]
[97,10]
[98,9]
[99,12]
[100,6]
[101,13]
[102,9]
[103,16]
[104,11]
[105,9]
[106,7]
[107,8]
[108,11]
[109,13]
[110,10]
[111,11]
[112,3]
[113,8]
[114,7]
[115,4]
[116,11]
[117,11]
[118,5]
[119,11]
[120,9]
[121,11]
[122,11]
[123,11]
[124,6]
[125,7]
[126,13]
[127,11]
[128,6]
[129,8]
[130,10]
[131,13]
[132,14]
[133,4]
[134,8]
[135,7]
[136,10]
[137,11]
[138,3]
[139,8]
[140,7]
[141,4]
[142,11]
[143,11]
[144,5]
[145,11]
[146,9]
[147,11]
[148,11]
[149,11]
[150,6]
[151,7]
[152,13]
[153,11]
[154,6]
[155,8]
[156,10]
[157,13]
[158,14]
[159,9]
[160,7]
[161,8]
[162,9]
[163,16]
[164,6]
[165,8]
[166,5]
[167,9]
[168,6]
[169,9]
[170,6]
[171,13]
[172,14]
[173,11]
[174,11]
[175,8]
[176,10]
[177,14]
[178,12]
[179,10]
[180,11]
[181,11]
[182,9]
[183,9]
[184,7]
[185,8]
[186,9]
[187,16]
[188,6]
[189,8]
[190,5]
[191,9]
[192,6]
[193,9]
[194,6]
[195,13]
[196,14]
[197,11]
[198,11]
[199,8]
[200,10]
[201,14]
[202,12]
[203,10]
[204,11]
[205,11]
[206,9]
[207,9]
[208,7]
[209,8]
[210,9]
[211,16]
[212,6]
[213,8]
[214,8]
[215,15]
[216,11]
[217,9]
[218,9]
[219,13]
[220,8]
[221,8]
[222,9]
[223,13]
[224,10]
[225,8]
[226,9]
[227,11]
[228,12]
[229,7]
[230,9]
[231,12]
[232,11]
[233,3]
[234,18]
[235,11]
[236,10]
[237,15]
[238,7]
[239,11]
[240,9]
[241,9]
[242,13]
[243,8]
[244,8]
[245,9]
[246,13]
[247,10]
[248,8]
[249,9]
[250,11]
[251,12]
[252,7]
[253,9]
[254,12]
[255,11]
[256,3]
[257,18]
[258,11]
[259,10]
[260,15]
[261,7]
[262,11]
[263,9]
[264,9]
[265,13]
[266,8]
[267,8]
[268,9]
[269,14]
[270,6]
[271,13]
[272,10]
[273,13]
[274,6]
[275,7]
[276,8]
[277,12]
[278,13]
[279,8]
[280,12]
[281,13]
[282,8]
[283,11]
[284,17]
[285,12]
[286,13]
[287,8]
[288,7]
[289,16]
[290,14]
[291,7]
[292,6]
[293,13]
[294,10]
[295,13]
[296,6]
[297,7]
[298,8]
[299,12]
[300,13]
[301,8]
[302,12]
[303,13]
[304,8]
[305,11]
[306,17]
[307,12]
[308,13]
[309,8]
[310,7]
[311,16]
[312,14]
[313,7]
[314,6]
[315,13]
[316,10]
[317,13]
[318,6]
[319,7]
[320,8]
[321,12]
[322,13]
[323,8]
[324,12]
[325,3]
[326,8]
[327,15]
[328,7]
[329,11]
[330,12]
[331,6]
[332,8]
[333,5]
[334,14]
[335,9]
[336,9]
[337,12]
[338,9]
[339,14]
[340,8]
[341,10]
[342,10]
[343,5]
[344,14]
[345,9]
[346,11]
[347,11]
[348,9]
[349,2]
[350,3]
[351,8]
[352,15]
[353,7]
[354,11]
[355,12]
[356,6]
[357,8]
[358,5]
[359,14]
[360,9]
[361,9]
[362,12]
[363,9]
[364,14]
[365,8]
[366,10]
[367,10]
[368,5]
[369,14]
[370,9]
[371,11]
[372,11]
[373,9]
[374,2]
[375,3]
[376,8]
[377,15]
[378,7]
[379,11]
[380,9]
[381,13]
[382,5]
[383,16]
[384,11]
[385,5]
[386,5]
[387,11]
[388,20]
[389,8]
[390,12]
[391,10]
[392,15]
[393,10]
[394,7]
[395,13]
[396,13]
[397,10]
[398,8]
[399,13]
[400,11]
[401,6]
[402,10]
[403,15]
[404,5]
[405,16]
[406,11]
[407,5]
[408,5]
[409,11]
[410,20]
[411,8]
[412,12]
[413,10]
[414,15]
[415,10]
[416,7]
[417,13]
[418,13]
[419,10]
[420,8]
[421,13]
[422,11]
[423,6]
[424,10]
[425,15]
[426,5]
[427,16]
[428,11]
[429,5]
[430,5]
[431,11]
[432,20]
[433,8]
[434,12]
[435,10]
[436,3]
[437,9]
[438,7]
[439,8]
[440,14]
[441,15]
[442,13]
[443,20]
[444,2]
[445,9]
[446,9]
[447,19]
[448,10]
[449,13]
[450,6]
[451,10]
[452,8]
[453,6]
[454,8]
[455,9]
[456,4]
[457,10]
[458,7]
[459,6]
[460,11]
[461,13]
[462,12]
[463,11]
[464,7]
[465,5]
[466,7]
[467,6]
[468,13]
[469,6]
[470,9]
[471,19]
[472,11]
[473,11]
[474,10]
[475,10]
[476,14]
[477,12]
[478,7]
[479,9]
[480,4]
[481,13]
[482,18]
[483,9]
[484,8]
[485,4]
[486,8]
[487,14]
[488,15]
[489,13]
[490,10]
[491,9]
[492,7]
[493,11]
[494,14]
[495,11]
[496,5]
[497,4]
[498,14]
[499,17]
[500,17]

{"sheet":"Cumul","index":8,"n_rows":525,"n_cols":6,"rows_kept":525,"cut":false,"hidden":false,"merged":[]}
["Distribuição \"ACUMULADA\""]
[]
["Características"]
["Contínua"]
["Pode ter qualquer forma"]
["Limitada em ambas direções"]
["Não necessariamente positiva (depende dos limites)"]
[]
["Parâmetros"]
["Percentís","Valor","Prob. Acum."]
["Min",10,0]
[null,12,0.25]
[null,15,0.5]
[null,19,0.75]
["Max",25,1]
[]
["Excel"]
["Não há um modo fácil de fazer isso exceto escrevendo uma macro."]
[]
["@RISK",null,"Exemplo"]
["=RISKCUMUL(Min,Max,intermediate values in increasing order,cumulative probabilities of intermediate values)"]
[null,null,{"$f":"_xll.RiskCumul(B11,B15,B12:B14,C12:C14)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,18.604083061218262,null,11,"10-11",{"$f":"FREQUENCY(B26:B525,D26:D39)","v":61}]
[2,10.290686517953873,null,12,"11-12",64]
[3,14.724828243255615,null,13,"12-13",54]
[4,15.06608772277832,null,14,"13-14",36]
[5,10.044251527637243,null,15,"14-15",49]
[6,24.419811725616455,null,16,"15-16",24]
[7,17.189845085144043,null,17,"16-17",38]
[8,14.294164538383484,null,18,"17-18",24]
[9,21.873451232910156,null,19,"18-19",30]
[10,13.939090490341187,null,20,"19-20",17]
[11,17.710757255554199,null,21,"20-21",18]
[12,17.164877891540527,null,22,"21-22",17]
[13,16.107827186584473,null,23,"22-23",27]
[14,21.15597677230835,null,24,"23-24",17]
[15,10.849131107330322,null,null,"24-25",24]
[16,15.256488800048828]
[17,18.065970420837402]
[18,16.928010940551758]
[19,18.504440307617188]
[20,22.86724328994751]
[21,20.26362943649292]
[22,22.516833782196045]
[23,21.266233444213867]
[24,18.745833396911621]
[25,19.340938091278076]
[26,24.006845951080322]
[27,14.008306503295898]
[28,13.66269314289093]
[29,18.91559886932373]
[30,10.96030980348587]
[31,12.431431889533997]
[32,14.955304026603699]
[33,10.148468911647797]
[34,10.857171297073364]
[35,10.200317680835724]
[36,17.995509147644043]
[37,22.396843910217285]
[38,11.37063467502594]
[39,21.696609973907471]
[40,22.426544189453125]
[41,11.5238436460495]
[42,11.797367691993713]
[43,11.208731770515442]
[44,12.931417107582092]
[45,13.289306402206421]
[46,13.016111254692078]
[47,20.542171478271484]
[48,13.99415123462677]
[49,15.360904693603516]
[50,11.397829532623291]
[51,19.332623958587646]
[52,14.876765370368958]
[53,20.785189628601074]
[54,20.929385185241699]
[55,16.483711242675781]
[56,11.831838965415955]
[57,10.142217606306076]
[58,13.4390709400177]
[59,14.749089002609253]
[60,12.819745302200317]
[61,10.674322783946991]
[62,14.586431622505188]
[63,16.26114559173584]
[64,24.446907043457031]
[65,11.768883466720581]
[66,14.337016582489014]
[67,14.810560584068298]
[68,11.932968854904175]
[69,14.788681983947754]
[70,19.515171527862549]
[71,18.228373527526855]
[72,12.30532693862915]
[73,10.783553183078766]
[74,15.708781242370605]
[75,11.178206205368042]
[76,12.755049347877502]
[77,10.57721471786499]
[78,10.112282745540142]
[79,11.13106107711792]
[80,15.563613891601562]
[81,23.580193042755127]
[82,10.379490345716476]
[83,22.827207565307617]
[84,14.116954207420349]
[85,10.285987019538879]
[86,20.690000534057617]
[87,23.018890380859375]
[88,10.33283320069313]
[89,22.26486349105835]
[90,16.284613609313965]
[91,11.624047636985779]
[92,17.398624420166016]
[93,18.023026466369629]
[94,10.727146506309509]
[95,11.527994394302368]
[96,22.960877418518066]
[97,11.013814568519592]
[98,16.708682060241699]
[99,11.44273853302002]
[100,10.35617133975029]
[101,12.150289177894592]
[102,20.205323219299316]
[103,12.29755961894989]
[104,24.69593620300293]
[105,11.871098756790161]
[106,18.4627685546875]
[107,16.284214973449707]
[108,13.775640606880188]
[109,20.07142448425293]
[110,19.535566329956055]
[111,12.738313436508179]
[112,24.428153038024902]
[113,14.806639194488525]
[114,22.571257591247559]
[115,10.922449231147766]
[116,14.212515950202942]
[117,19.638322830200195]
[118,14.855139255523682]
[119,19.862924575805664]
[120,12.672886490821838]
[121,12.816294550895691]
[122,22.058097362518311]
[123,10.490230411291122]
[124,14.254424929618835]
[125,15.143061637878418]
[126,22.637237071990967]
[127,10.005178207997233]
[128,10.884907901287079]
[129,12.724937796592712]
[130,14.170232534408569]
[131,18.722517013549805]
[132,17.786909103393555]
[133,11.755141377449036]
[134,13.428808450698853]
[135,11.789598107337952]
[136,24.15203857421875]
[137,16.01679515838623]
[138,10.085316605865955]
[139,12.733280181884766]
[140,16.621953010559082]
[141,10.350559204816818]
[142,14.154305577278137]
[143,12.067788004875183]
[144,16.279394149780273]
[145,12.147165298461914]
[146,12.907022595405579]
[147,16.418163299560547]
[148,12.012845277786255]
[149,16.31123161315918]
[150,12.473373413085938]
[151,22.945342063903809]
[152,10.128906637430191]
[153,12.556574106216431]
[154,18.991833686828613]
[155,12.742368936538696]
[156,16.413476943969727]
[157,16.293266296386719]
[158,22.737501621246338]
[159,19.327140808105469]
[160,12.230628490447998]
[161,11.222987055778503]
[162,16.113581657409668]
[163,10.694906830787659]
[164,11.546164989471436]
[165,18.655925750732422]
[166,22.168015003204346]
[167,18.528385162353516]
[168,22.694187164306641]
[169,17.18461799621582]
[170,19.953301429748535]
[171,21.297786235809326]
[172,15.408421516418457]
[173,22.743432521820068]
[174,14.958088517189026]
[175,13.700215101242065]
[176,12.622934818267822]
[177,16.296632766723633]
[178,12.741470217704773]
[179,11.008037209510803]
[180,23.094377040863037]
[181,12.848668456077576]
[182,10.759344100952148]
[183,13.163791179656982]
[184,10.32953953742981]
[185,12.335752129554749]
[186,11.304467797279358]
[187,16.3970947265625]
[188,10.208976298570633]
[189,17.249152183532715]
[190,13.10038948059082]
[191,11.953153967857361]
[192,17.55400276184082]
[193,13.489511132240295]
[194,15.342172622680664]
[195,19.135143280029297]
[196,15.292696952819824]
[197,15.376786231994629]
[198,19.219398975372314]
[199,11.50622022151947]
[200,24.048460960388184]
[201,18.912731170654297]
[202,12.322152256965637]
[203,11.000526309013367]
[204,17.581645965576172]
[205,24.249409198760986]
[206,20.667309761047363]
[207,17.70609188079834]
[208,12.062264800071716]
[209,14.658123135566711]
[210,11.190444946289063]
[211,10.008190943859518]
[212,15.875313758850098]
[213,12.18188738822937]
[214,14.063181281089783]
[215,10.200598374009132]
[216,14.918977975845337]
[217,11.563783407211304]
[218,16.047641754150391]
[219,14.251676201820374]
[220,11.681614518165588]
[221,13.30141818523407]
[222,24.073178768157959]
[223,18.450351715087891]
[224,17.818977355957031]
[225,10.361401915550232]
[226,16.102321624755859]
[227,13.805526852607727]
[228,11.956987619400024]
[229,15.444511413574219]
[230,16.155413627624512]
[231,17.12448787689209]
[232,12.910209774971008]
[233,21.166694164276123]
[234,24.452776432037354]
[235,23.069805145263672]
[236,19.384365558624268]
[237,20.914257526397705]
[238,23.201219081878662]
[239,10.128941163420677]
[240,19.833547592163086]
[241,24.222053527832031]
[242,10.174726769328117]
[243,16.415718078613281]
[244,14.164442181587219]
[245,24.597943305969238]
[246,12.393141388893127]
[247,23.655478000640869]
[248,18.167037963867188]
[249,14.714526414871216]
[250,11.493886947631836]
[251,10.942663967609406]
[252,12.347108244895935]
[253,11.850876927375793]
[254,16.857027053833008]
[255,12.930864930152893]
[256,14.024338245391846]
[257,14.238805174827576]
[258,11.182934045791626]
[259,18.868442535400391]
[260,11.621681332588196]
[261,24.753052234649658]
[262,18.905279159545898]
[263,11.912568688392639]
[264,17.988466262817383]
[265,11.449760437011719]
[266,24.500392436981201]
[267,24.189394950866699]
[268,21.034891128540039]
[269,14.264209985733032]
[270,18.877008438110352]
[271,15.788318634033203]
[272,14.970396637916565]
[273,10.714136481285095]
[274,12.01084578037262]
[275,10.738950610160828]
[276,10.636206448078156]
[277,18.680365562438965]
[278,10.796662032604218]
[279,13.18336808681488]
[280,17.023686408996582]
[281,11.058623790740967]
[282,12.031125783920288]
[283,15.0455322265625]
[284,12.900861740112305]
[285,16.32004451751709]
[286,22.328813076019287]
[287,10.6942378282547]
[288,11.227998495101929]
[289,20.103495121002197]
[290,23.569412708282471]
[291,20.194970607757568]
[292,24.879367828369141]
[293,14.836399912834167]
[294,12.285655617713928]
[295,11.883689761161804]
[296,14.640629768371582]
[297,23.381771087646484]
[298,13.050942420959473]
[299,13.056016087532043]
[300,22.689323425292969]
[301,15.843823432922363]
[302,21.265491008758545]
[303,13.191910028457642]
[304,21.393523216247559]
[305,10.435263097286224]
[306,21.765740871429443]
[307,19.625918865203857]
[308,22.750906944274902]
[309,10.268491268157959]
[310,14.266458034515381]
[311,12.98298168182373]
[312,12.396807432174683]
[313,13.222653150558472]
[314,20.23325252532959]
[315,13.835036516189575]
[316,24.873685836791992]
[317,12.092559099197388]
[318,24.16639518737793]
[319,14.415814518928528]
[320,18.378681182861328]
[321,10.372873842716217]
[322,17.058340072631836]
[323,14.961429119110107]
[324,15.55939769744873]
[325,11.516592621803284]
[326,18.27799129486084]
[327,11.185657739639282]
[328,11.916295170783997]
[329,11.571967482566833]
[330,11.817037105560303]
[331,12.641350507736206]
[332,20.76963996887207]
[333,10.528170764446259]
[334,22.833820819854736]
[335,12.534782767295837]
[336,21.382256507873535]
[337,22.616945266723633]
[338,18.223363876342773]
[339,23.131650447845459]
[340,16.404254913330078]
[341,17.095796585083008]
[342,10.972106099128723]
[343,18.23491096496582]
[344,10.678491175174713]
[345,22.450791358947754]
[346,11.36915385723114]
[347,14.978254437446594]
[348,23.833703994750977]
[349,10.673844337463379]
[350,15.489388465881348]
[351,12.862143158912659]
[352,18.088590621948242]
[353,11.128660917282104]
[354,10.88697361946106]
[355,16.604414939880371]
[356,18.6640625]
[357,19.680979251861572]
[358,14.274999976158142]
[359,15.882638931274414]
[360,11.641177535057068]
[361,24.148795604705811]
[362,10.596957504749298]
[363,24.619256496429443]
[364,14.349546074867249]
[365,20.38922119140625]
[366,11.683215022087097]
[367,16.29416561126709]
[368,12.204916477203369]
[369,22.782461166381836]
[370,11.854203701019287]
[371,14.958588123321533]
[372,12.675707101821899]
[373,22.144862174987793]
[374,23.097547054290771]
[375,13.671867728233337]
[376,13.242868065834045]
[377,14.850763320922852]
[378,13.630968689918518]
[379,23.432472705841064]
[380,14.52684223651886]
[381,23.236007690429688]
[382,18.337982177734375]
[383,17.949952125549316]
[384,24.792369842529297]
[385,12.15115749835968]
[386,11.830609440803528]
[387,21.150383472442627]
[388,16.923613548278809]
[389,10.814866483211517]
[390,10.673306882381439]
[391,12.22050404548645]
[392,17.138073921203613]
[393,20.052584648132324]
[394,18.046026229858398]
[395,10.729735195636749]
[396,12.896140336990356]
[397,11.923818707466125]
[398,19.754819393157959]
[399,18.127825736999512]
[400,15.643369674682617]
[401,17.937290191650391]
[402,10.898190498352051]
[403,10.133743494749069]
[404,16.97856616973877]
[405,16.665383338928223]
[406,16.811542510986328]
[407,10.069319218397141]
[408,11.197870969772339]
[409,21.358605861663818]
[410,13.457397222518921]
[411,22.345710277557373]
[412,11.265186309814453]
[413,13.052700519561768]
[414,14.652018785476685]
[415,23.482524871826172]
[416,12.970842361450195]
[417,12.369144201278687]
[418,12.525108933448792]
[419,13.254943370819092]
[420,14.7984699010849]
[421,24.278188228607178]
[422,20.186429023742676]
[423,16.14539623260498]
[424,13.408703684806824]
[425,15.771117210388184]
[426,13.611302375793457]
[427,12.475091814994812]
[428,12.088506817817688]
[429,12.799736022949219]
[430,19.62642240524292]
[431,13.138889193534851]
[432,13.053956866264343]
[433,15.602221488952637]
[434,16.011785507202148]
[435,16.138648986816406]
[436,19.440448760986328]
[437,13.450786113739014]
[438,11.706963419914246]
[439,10.436615020036697]
[440,23.360630989074707]
[441,23.753539562225342]
[442,15.733443260192871]
[443,12.187766790390015]
[444,16.898439407348633]
[445,10.913910627365112]
[446,14.627289533615112]
[447,10.496338903903961]
[448,14.117588639259338]
[449,11.137454271316528]
[450,18.311067581176758]
[451,10.280699044466019]
[452,24.594442844390869]
[453,14.577673673629761]
[454,23.065316200256348]
[455,11.562425255775452]
[456,13.149010419845581]
[457,16.194159507751465]
[458,14.441775798797607]
[459,10.419958293437958]
[460,21.057626247406006]
[461,11.938580393791199]
[462,20.087067127227783]
[463,10.761255979537964]
[464,22.997974872589111]
[465,14.080627083778381]
[466,13.122772336006165]
[467,22.42002534866333]
[468,18.505160331726074]
[469,13.281152844429016]
[470,14.613972902297974]
[471,12.226333737373352]
[472,21.503111839294434]
[473,11.212618470191956]
[474,17.362190246582031]
[475,14.377421379089355]
[476,24.683745384216309]
[477,13.015540838241577]
[478,17.435185432434082]
[479,11.376710534095764]
[480,11.619551777839661]
[481,20.431365489959717]
[482,21.066632747650146]
[483,11.639046192169189]
[484,14.770922899246216]
[485,15.540453910827637]
[486,15.793807983398438]
[487,11.941381931304932]
[488,16.936904907226562]
[489,11.118808150291443]
[490,11.820809602737427]
[491,22.020423412322998]
[492,17.429221153259277]
[493,21.558584213256836]
[494,16.387932777404785]
[495,17.605308532714844]
[496,10.750142991542816]
[497,13.731154918670654]
[498,16.888165473937988]
[499,11.364272356033325]
[500,11.019328713417053]

{"sheet":"General","index":9,"n_rows":525,"n_cols":6,"rows_kept":525,"cut":false,"hidden":false,"merged":[]}
["Distribuição \"GERAL\""]
[]
["Características"]
["Contínuo"]
["Pode ter qualquer forma"]
["Limitado em ambas direções"]
["Não necessariamente positivo (depende dos limites)"]
[]
["Parâmetros"]
[null,"Valor","Chance relativa"]
["Min",10]
[null,12,2]
[null,15,4]
[null,19,1]
["Max",25]
[]
["Método Excel"]
["Não há um modo fácil de fazer isso exceto escrevendo uma macro."]
[]
["@RISK",null,"Exemplo"]
["=RISKGENERAL(Min,Max,intermediate values in increasing order,Relative likelihoods of intermediate values)"]
[null,null,{"$f":"_xll.RiskGeneral(B11,B15,B12:B14,C12:C14)","v":{"$error":"#NAME?"}}]
[]
["Dados para o Histograma (após gerar um então congelar números aleatórios na coluna B)"]
["Obs #","Observação",null,"Limite Superior","Categoria","Frequência"]
[1,15.01417828697754,null,11,"10-11",{"$f":"FREQUENCY(B26:B525,D26:D39)","v":10}]
[2,14.357373656342032,null,12,"11-12",31]
[3,14.98266905928719,null,13,"12-13",48]
[4,18.17340244811945,null,14,"13-14",70]
[5,14.560653251378094,null,15,"14-15",66]
[6,11.97151679943337,null,16,"15-16",68]
[7,17.129108235363255,null,17,"16-17",62]
[8,13.127342339363269,null,18,"17-18",51]
[9,12.878920448484681,null,19,"18-19",33]
[10,13.237893940328926,null,20,"19-20",18]
[11,10.847331103357659,null,21,"20-21",16]
[12,15.536440528684532,null,22,"21-22",13]
[13,16.546613405808188,null,23,"22-23",6]
[14,15.575773488395132,null,24,"23-24",6]
[15,14.299354513016034,null,null,"24-25",2]
[16,11.845940274943159]
[17,14.429858922653688]
[18,23.022502170568757]
[19,20.722602071190728]
[20,19.949762572780458]
[21,11.685849336116689]
[22,11.65242642676027]
[23,12.167867054465281]
[24,14.757831858132686]
[25,22.601507231016484]
[26,16.242478738584769]
[27,15.105369939348337]
[28,14.238699945362251]
[29,15.01602763206675]
[30,18.144568721041296]
[31,10.39403031906755]
[32,17.489239425867062]
[33,13.72454402479414]
[34,19.421802681502143]
[35,21.380945279790442]
[36,12.431244082002801]
[37,14.119329711728646]
[38,15.643618777605708]
[39,14.991569855252298]
[40,17.228721019126006]
[41,12.841007417243127]
[42,13.109997560750976]
[43,10.83934622821082]
[44,14.789536059080074]
[45,14.025428958632459]
[46,19.383209115184187]
[47,18.404158124400212]
[48,17.732090671510349]
[49,17.246085924329826]
[50,17.767860131902417]
[51,12.203029445060277]
[52,14.501404041195688]
[53,17.355044549849332]
[54,16.778284320885998]
[55,17.928008726740593]
[56,14.775150586926848]
[57,12.062700722402987]
[58,15.673471462057579]
[59,19.008647952074373]
[60,13.706105577297022]
[61,17.296197093388734]
[62,13.023948133341975]
[63,17.085913223075909]
[64,14.734934059768372]
[65,11.462054779068875]
[66,18.059789472914431]
[67,15.439509118194806]
[68,13.620564498969665]
[69,13.503486435076187]
[70,14.99751993421682]
[71,13.392968919873764]
[72,15.723743255518103]
[73,13.443518908644478]
[74,12.58194400593748]
[75,17.904685594206462]
[76,16.561824290082257]
[77,13.906602616000047]
[78,14.59048752506421]
[79,15.978148462321778]
[80,15.639076005901558]
[81,15.599801709742176]
[82,19.972296027437796]
[83,15.034952193407173]
[84,13.128512187764677]
[85,11.823493274139729]
[86,18.031783912398321]
[87,11.357442007670226]
[88,18.552409121913669]
[89,18.451142149361335]
[90,12.541290238889374]
[91,15.882779500424054]
[92,11.799614849210593]
[93,14.09666661269789]
[94,24.465831917116454]
[95,15.421522652733447]
[96,15.876897484825069]
[97,21.621964865723239]
[98,19.075957440824727]
[99,16.028746956691649]
[100,16.144167597188826]
[101,15.915004203392598]
[102,14.963180160115407]
[103,13.089782320889292]
[104,13.131352518284169]
[105,13.561003687849773]
[106,13.071713065662337]
[107,20.039110751649517]
[108,15.71226155076779]
[109,16.201520695014842]
[110,23.517416016768703]
[111,14.53067744249709]
[112,13.466350591505252]
[113,16.876536147479722]
[114,17.13405390481163]
[115,16.495600861153711]
[116,16.653340655808663]
[117,18.760267521600891]
[118,17.095691342646614]
[119,19.354147841894324]
[120,14.962273484251892]
[121,18.710620500847767]
[122,16.314529219445085]
[123,16.24489601090222]
[124,16.0153234423763]
[125,18.681958606190005]
[126,17.464134355974974]
[127,14.510836481304684]
[128,11.335860802305955]
[129,19.352901379991962]
[130,16.094416340323516]
[131,17.374398091258669]
[132,16.946869277606918]
[133,17.272384032741218]
[134,16.034591827425619]
[135,12.952347237894028]
[136,14.083758401556601]
[137,13.138076343328102]
[138,16.92522099472238]
[139,15.399443925803331]
[140,14.497529580425706]
[141,21.436059540292263]
[142,13.955460824949569]
[143,21.775567783390876]
[144,14.60944013637457]
[145,13.743741354350176]
[146,20.943538987486146]
[147,14.801952698456578]
[148,16.799606186842791]
[149,12.605077439189369]
[150,17.223452440411769]
[151,13.276491806678054]
[152,20.296994638538923]
[153,23.209872233938807]
[154,23.411066489264549]
[155,18.729714491285527]
[156,18.980088611365559]
[157,16.694054615559835]
[158,15.764394162591197]
[159,10.982182923032296]
[160,20.509189451861449]
[161,23.523751428461079]
[162,13.112727809961854]
[163,11.497237701912013]
[164,13.64449226228281]
[165,11.323103511060983]
[166,12.00529549051941]
[167,13.748423892092999]
[168,14.107940472446419]
[169,15.082479899508019]
[170,17.005939816749585]
[171,13.701298279721021]
[172,12.776807902849717]
[173,15.932404059466442]
[174,12.593239125967242]
[175,13.501146845908123]
[176,20.789167585958729]
[177,16.404126485933624]
[178,16.314095452950298]
[179,17.194640324195642]
[180,22.992272523535384]
[181,11.938823125113178]
[182,17.813002202901099]
[183,10.905450599890047]
[184,21.576209199611604]
[185,16.15193091345466]
[186,15.737273389743313]
[187,16.531084121769172]
[188,15.246365455089784]
[189,15.771172058509269]
[190,12.096651046461684]
[191,11.482581329816639]
[192,19.010883188033652]
[193,13.57719990103349]
[194,17.678244850945038]
[195,12.334760257162095]
[196,17.761745698321576]
[197,16.724183574473315]
[198,18.120118839283048]
[199,12.769017729098351]
[200,14.189977031502588]
[201,13.822320875219829]
[202,17.479285175342767]
[203,21.555985675854849]
[204,12.74223525110412]
[205,16.501440069929004]
[206,14.695126063431097]
[207,19.800259427893359]
[208,11.19148381715511]
[209,14.388734768054224]
[210,13.885815946398504]
[211,13.147777655759864]
[212,13.148735121918401]
[213,24.472265769568857]
[214,20.464705595006446]
[215,19.224564130313343]
[216,12.379726623435689]
[217,20.981925316296579]
[218,13.614462498560314]
[219,12.667517052281216]
[220,13.479464364324052]
[221,14.539495303270016]
[222,14.920991091826686]
[223,12.858181077632109]
[224,12.611958607030918]
[225,14.940515996985452]
[226,15.192299737649234]
[227,13.150853848805198]
[228,14.933504225737991]
[229,15.035971234768153]
[230,18.188751585705091]
[231,11.245404306854317]
[232,16.17022012283072]
[233,13.877292534166539]
[234,15.003833240941081]
[235,17.631597485087664]
[236,19.143908634929797]
[237,17.825310335315109]
[238,12.061369619201464]
[239,11.898829101863594]
[240,15.336250223519063]
[241,16.145731406875065]
[242,14.782948837177965]
[243,14.332674964362933]
[244,14.245895552424022]
[245,16.793495500810355]
[246,15.935246326655871]
[247,16.824241216444833]
[248,12.302198351873532]
[249,14.270634495398546]
[250,16.101667819820207]
[251,15.944531174670312]
[252,13.59775166505708]
[253,14.390658104836358]
[254,14.136110543915272]
[255,13.960777508416054]
[256,16.305952274377333]
[257,15.173508179774137]
[258,15.255162969286491]
[259,14.405194306246655]
[260,17.67578555625655]
[261,15.962817452524883]
[262,17.998798407274041]
[263,21.378465401532054]
[264,18.478766552380407]
[265,16.400475333535145]
[266,17.467684413390831]
[267,18.395311870129099]
[268,16.379259011556712]
[269,13.353680819307595]
[270,13.839643423446631]
[271,14.68115251161635]
[272,18.237677737543212]
[273,19.906347544849343]
[274,15.397842966428442]
[275,16.195151944931553]
[276,12.542130409995572]
[277,11.999823711493667]
[278,18.334651957858892]
[279,18.319367111346203]
[280,17.75772141173146]
[281,10.381021010505703]
[282,16.711287492757208]
[283,11.998390772245633]
[284,16.489212784541071]
[285,13.39487775326641]
[286,13.296261067313756]
[287,16.536367018916408]
[288,14.887047265498243]
[289,17.742199032296391]
[290,10.827299849558504]
[291,11.32965383610321]
[292,12.675947487585756]
[293,18.818208302816036]
[294,17.664364060479496]
[295,12.260722719804448]
[296,17.702361023314026]
[297,15.338119720895794]
[298,18.191967327476441]
[299,16.778622343446049]
[300,15.748968760588882]
[301,15.365882984860249]
[302,18.885309090711292]
[303,13.739998150233619]
[304,15.548411154038394]
[305,16.0788577837966]
[306,19.742561705076628]
[307,12.892167945913769]
[308,16.64354120432823]
[309,12.172488233170206]
[310,12.025137076148891]
[311,22.151701822931251]
[312,11.503529925140857]
[313,16.748418402954758]
[314,14.309377313515718]
[315,17.264153048383005]
[316,14.999860225479924]
[317,21.232369478154006]
[318,12.838612169768206]
[319,17.135882317297945]
[320,18.809150100166775]
[321,13.672551772686491]
[322,10.788758568724745]
[323,21.326538688318216]
[324,16.288911428036922]
[325,17.379188171091947]
[326,15.492246861075341]
[327,15.67540587417411]
[328,14.410276269786454]
[329,19.693092866751591]
[330,17.01939599213906]
[331,21.773681058678047]
[332,14.596009954059191]
[333,17.127955423154116]
[334,17.247232184477202]
[335,18.135395261076294]
[336,21.437338581730565]
[337,23.902637453105779]
[338,17.040358919867792]
[339,20.089981845803813]
[340,17.399488771078357]
[341,13.691121190389213]
[342,15.348555105183914]
[343,16.701251870335568]
[344,20.554913839997177]
[345,17.234071172653863]
[346,11.070438809146639]
[347,13.10927832602151]
[348,13.338140598121237]
[349,11.09666857284933]
[350,15.714333608929]
[351,13.429566598685433]
[352,12.695636856005892]
[353,20.475482970663624]
[354,22.271987382509653]
[355,16.008607022143941]
[356,12.453210795100512]
[357,12.492832713079315]
[358,15.360706703345505]
[359,16.89206576810215]
[360,16.424369540768048]
[361,19.858360877541035]
[362,14.860726040529231]
[363,17.459804008069909]
[364,14.17185222701392]
[365,18.051976501086457]
[366,14.993814916328784]
[367,14.313372013106008]
[368,17.42459260574913]
[369,15.910723911582657]
[370,17.024609428802979]
[371,13.702356370743235]
[372,17.017616857923066]
[373,12.59595894304988]
[374,12.937054427231182]
[375,16.198431730917079]
[376,12.342904171071398]
[377,12.00849177629267]
[378,22.539868295985226]
[379,11.326435562908149]
[380,16.251666194884127]
[381,14.695128324065994]
[382,11.507662276458477]
[383,16.288441270346325]
[384,13.488783765903269]
[385,18.073374617361964]
[386,15.438856337106245]
[387,16.075493159175053]
[388,14.717796183605214]
[389,20.591208683528741]
[390,14.444206508586253]
[391,15.971370345567939]
[392,13.383756158594352]
[393,12.578445336940659]
[394,13.035968414436352]
[395,15.274081755623733]
[396,15.46847894349588]
[397,14.487719437158908]
[398,15.403477229150011]
[399,13.928984675053311]
[400,16.225767146116429]
[401,20.837181062287392]
[402,13.289432530518274]
[403,13.022476362961479]
[404,14.526891640009683]
[405,12.816210176551868]
[406,13.026349704435235]
[407,15.26175936713954]
[408,16.649495824737077]
[409,12.726301747922193]
[410,11.984814272342369]
[411,15.284242741684167]
[412,16.870089788049569]
[413,15.815857477168773]
[414,14.295092324918981]
[415,11.676318102654333]
[416,16.582608215360771]
[417,13.954073048063453]
[418,15.853416848658362]
[419,18.131027674642603]
[420,13.875448353030356]
[421,11.968206148870179]
[422,18.137041207166742]
[423,15.099829194250391]
[424,21.522472044167905]
[425,17.669360488307028]
[426,11.573302994162127]
[427,15.567852107203475]
[428,17.26150990767993]
[429,10.790331820458842]
[430,14.962710915439834]
[431,16.024270904076495]
[432,14.596250177774944]
[433,18.142769963358514]
[434,21.383324809750992]
[435,12.596869715099281]
[436,16.673071936171759]
[437,15.030763959397728]
[438,13.955370974429353]
[439,12.991756020238062]
[440,12.616709848591482]
[441,13.41664646102074]
[442,11.206372868501335]
[443,15.82650986885905]
[444,16.264005585290583]
[445,13.881457746629787]
[446,17.508303073981349]
[447,17.210738569397385]
[448,12.97851355753467]
[449,14.592216579876455]
[450,14.957478350761287]
[451,22.924792509226911]
[452,16.088668831387789]
[453,15.319720509791876]
[454,18.38761909408219]
[455,11.127802735157184]
[456,15.558372583822447]
[457,14.549560369657968]
[458,13.410260870801689]
[459,13.539720313620009]
[460,15.053237429182934]
[461,16.913572208549834]
[462,13.18429516808021]
[463,15.326572623223916]
[464,10.732454558596935]
[465,18.545092168305189]
[466,15.095608382907068]
[467,12.515263297229811]
[468,20.838663789697378]
[469,11.67518589141214]
[470,13.81595900934936]
[471,20.592275663254863]
[472,12.422611601467997]
[473,13.141105595174377]
[474,14.481973627708264]
[475,13.984638219119477]
[476,15.006677396910028]
[477,14.084455634604899]
[478,16.164216215357062]
[479,20.558734825583223]
[480,13.546034981124356]
[481,16.436360571716989]
[482,14.099123478346183]
[483,15.324481618989651]
[484,15.553865741424801]
[485,17.02819003299285]
[486,14.709873439535317]
[487,19.175611778591119]
[488,17.985166289651467]
[489,12.213634945068497]
[490,16.423284019961137]
[491,15.673407200137628]
[492,15.406967118494101]
[493,13.51069070572348]
[494,19.611365644385781]
[495,13.235280351873541]
[496,12.285193335361239]
[497,18.232381021372579]
[498,13.254124617423273]
[499,14.246334431141319]
[500,18.172788808566388]